answersLogoWhite

0

Put your two times in separate cells and subtract the cells to determine the difference between the two times. You can format the times and the answer to display in a variety of time formats.

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

What is the spreadsheet formula to calculate the difference between two numbers?

It depends which spreadsheet package you're using, and how its syntax is set but - something like... D3=A3-B3 or D3=sum(A3-B3)


Does a spreadsheet calculate formulas?

Yes.


What automates tasks on a spreadsheet?

auto calculate


What is the difference between spreadsheet package and electronic spreadsheet?

Probably nothing. Sounds like semantics to me.


How do you calculate the time difference when longitudinal difference is given?

30 degree East and 80 degree west time difference


What do spreadsheets calculate?

Spreadsheets can calculate just about anything you want. That is their purpose. If you know what you want to calculate and how to do it, then you can use a spreadsheet to do it.


What is the difference between a spreadsheet app and a word processing app?

A spreadsheet app has rows and columns. Word processing just goes down the page.


Are there any internet Date Time calculators that can calculate the exact middle date and time between two dates?

You can easily do this with Microsoft Excel or OpenOffice's spreadsheet module.


What is auto calculate?

In Microsoft Excel, there are two calculation methods. Usually it is set to Auto Calculate, which means that every time a cell is changed, it goes through and recalculates every formula in the spreadsheet. If you have a very large spreadsheet, this can slow things down, especially if you have several cells to make changes to. If you change the settings to Manual Calculation, then you can make all of your changes, then tell it to recalculate the spreadsheet.


How do you calculate the change in time for a given scenario?

To calculate the change in time for a given scenario, subtract the initial time from the final time. This will give you the difference in time between the two points.


How can one calculate displacement from a position-time graph?

To calculate displacement from a position-time graph, find the difference between the initial and final positions on the graph. This difference represents the total displacement traveled by the object.


How can spreadsheet be used in science?

to organize data, draw graphs, calculate possible results