| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
calculate the time between to dates and times
I need to calculate the total time elapsed between two dates and times. What
should I do? Here's an example. Start date/time is 8/24/07 06:15 and the ending date/time is 8/26/07 12:00 (noon). How do I find the total elapsed time? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
calculate the time between to dates and times
Assuming 8/24/07 06:15 is in A1 and 8/26/07 12:00 is in B1, in C1 enter this
formula: =A1-B1 then, apply a custom format like [h]:mm to C1. -- Hope that helps. Vergel Adriano "Purple Queen" wrote: I need to calculate the total time elapsed between two dates and times. What should I do? Here's an example. Start date/time is 8/24/07 06:15 and the ending date/time is 8/26/07 12:00 (noon). How do I find the total elapsed time? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
calculate the time between to dates and times
sorry, I meant:
=B1-A1 -- Hope that helps. Vergel Adriano "Vergel Adriano" wrote: Assuming 8/24/07 06:15 is in A1 and 8/26/07 12:00 is in B1, in C1 enter this formula: =A1-B1 then, apply a custom format like [h]:mm to C1. -- Hope that helps. Vergel Adriano "Purple Queen" wrote: I need to calculate the total time elapsed between two dates and times. What should I do? Here's an example. Start date/time is 8/24/07 06:15 and the ending date/time is 8/26/07 12:00 (noon). How do I find the total elapsed time? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate times between dates and times in Excel | Excel Discussion (Misc queries) | |||
| formula to calculate difference between dates and times | Excel Discussion (Misc queries) | |||
| calculate elapsed time between dates and times | Excel Worksheet Functions | |||
| how do I calculate difference between two dates and times | Excel Programming | |||
| Formula to calculate elapsed time between certain dates and times | Excel Discussion (Misc queries) | |||
Linear Mode
