Home 
Search 
Today's Posts 
#1




How do I add times that were creted with "=TEXT(A2A1,"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(A2A1,"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! 
#2




How do I add times that were creted with "=TEXT(A2A1,"h:mm")"?
Replace the formula by =A2A1 and format [h]:mm (the [] stops 25 becoming 1)
using FormatCellscustom Now you can add the data in two or more cells. best wishes  Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Jaclyn" wrote in message ... 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(A2A1,"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! 
#3




How do I add times that were creted with "=TEXT(A2A1,"h:mm")"?
You could convert that back to a usable time with =time(a3) (if the formula
you have is in A3); format the result as a time. But even easier, skip the conversion to text and back. Instead of =text(...), just use =a2a1, formatted as a time. This is readable, and still usable in further calculations. Bruce "Jaclyn" wrote: 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(A2A1,"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! 
#4




How do I add times that were creted with "=TEXT(A2A1,"h:mm")"
Thank you. This worked out well.
"Bernard Liengme" wrote: Replace the formula by =A2A1 and format [h]:mm (the [] stops 25 becoming 1) using FormatCellscustom Now you can add the data in two or more cells. best wishes  Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Jaclyn" wrote in message ... 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(A2A1,"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! 
Reply 
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) 