Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I add times that were creted with "=TEXT(A2-A1,"h:mm")"?
I am trying to create a timecard which allows work shifts that span days. I
enter "time in" and "time out" for each shift in the format "mm/dd/yyyy hh:mm:ss". To find the total time at the end of a shift I used "=TEXT(A2-A1,"h:mm")" to subtract the time in from the time out, which gives me the total hours and minutes worked each shift. Now I can't seem to find a way to add all of the resulting shift times together to get a weekly total. All suggections welcome. Thank you! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting multiple minimum times | Excel Discussion (Misc queries) | |||
Charting and analyzing Times' times data for trends | Excel Discussion (Misc queries) | |||
Copy from worksheet to another x times | Excel Discussion (Misc queries) | |||
SUMPRODUCT ON TIMES | Excel Worksheet Functions | |||
Adding/Averaging Times in Excel | Excel Discussion (Misc queries) |