| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtracting Time
I have for example 8:15:29 AM in one cell and 9:33:15 AM in another cell and
I need the amount of time between the the two |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Subtracting Time
Assuming times are in A2 and A3 respectively:
=A3-A2 format cell as time. (answer is 1:17:46) if you want answer in hours, multiply by 24 In minutes, multiply by 24*60 in seconds, multiply by 24*60*60 -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Mark" wrote: I have for example 8:15:29 AM in one cell and 9:33:15 AM in another cell and I need the amount of time between the the two |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Subtracting Time
=B2-A2 and format as [h]:mm:ss
-- David Biddulph Mark wrote: I have for example 8:15:29 AM in one cell and 9:33:15 AM in another cell and I need the amount of time between the the two |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Subtracting a duration from a time to calculate a time. | Excel Discussion (Misc queries) | |||
| Subtracting Dates to get total time work time excluding weekends | Excel Discussion (Misc queries) | |||
| Subtracting Time | Excel Worksheet Functions | |||
| Subtracting time | Excel Worksheet Functions | |||
Linear Mode
