Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculating Time
I am working on a time management log that captures the time they
start and the time they stop in the spreadsheet. In another column I use the =TEXT(F2-E2, "h:mm:ss") function to calculate the elapsed time. How do I calculate the column of elapsed times? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculating Time
Hi
in this other column don't use this formula as it creates a string value. Use the formula =F2-E2 and format this cell with the format hh:mm:ss Now to add these data use a formula like =SUM(G2:G10) and format this cell with the custom format [hh]:mm note the '[' brackets. They prevent the rollover after 24 hours -- Regards Frank Kabel Frankfurt, Germany Tamara wrote: I am working on a time management log that captures the time they start and the time they stop in the spreadsheet. In another column I use the =TEXT(F2-E2, "h:mm:ss") function to calculate the elapsed time. How do I calculate the column of elapsed times? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculating Time
Thanks so much, Frank!
*** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time Sheet - Calculating Time Differences for Totals | Excel Discussion (Misc queries) | |||
Calculating Time with Date/Time checking in formula | Excel Worksheet Functions | |||
Calculating Regular time, overtime and double time | Excel Worksheet Functions | |||
calculating timesheet, time-in/time-out = total hours & minutes, . | Excel Worksheet Functions |