Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I get elapsed time between AM start/PM stop
I have a simple spreadsheet with start and stop times.
I want to calculate elapsed time but can't determine how to calculate time between 11:20 a.m. and 2:00 p.m. for instance. |
#2
|
|||
|
|||
You will need to enter the data as 11:20 AM or 2:00 PM for it to work or as
military time, 11:20 or 14:00. Then just simply subtract one from the other and format as time -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "khacmac" wrote in message ... I have a simple spreadsheet with start and stop times. I want to calculate elapsed time but can't determine how to calculate time between 11:20 a.m. and 2:00 p.m. for instance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
elapsed time calculation | Excel Discussion (Misc queries) | |||
How do I stop Excel from closing the open file each time I open a. | Setting up and Configuration of Excel | |||
Can't stop time duration [hh]:mm:ss converting to time of day | Excel Discussion (Misc queries) | |||
Elapsed time Calc...over 30 days long... | Excel Discussion (Misc queries) | |||
Elapsed time Calc...over 30 days long... | Excel Discussion (Misc queries) |