Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 29th 05, 04:55 PM posted to microsoft.public.excel.worksheet.functions
Jaclyn
 
Posts: n/a
Default 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!

  #2   Report Post  
Old December 29th 05, 05:12 PM posted to microsoft.public.excel.worksheet.functions
Bernard Liengme
 
Posts: n/a
Default How do I add times that were creted with "=TEXT(A2-A1,"h:mm")"?

Replace the formula by =A2-A1 and format [h]:mm (the [] stops 25 becoming 1)
using Format|Cells-custom
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(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!



  #3   Report Post  
Old December 29th 05, 05:16 PM posted to microsoft.public.excel.worksheet.functions
bpeltzer
 
Posts: n/a
Default How do I add times that were creted with "=TEXT(A2-A1,"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 =a2-a1,
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(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!

  #4   Report Post  
Old December 29th 05, 05:31 PM posted to microsoft.public.excel.worksheet.functions
Jaclyn
 
Posts: n/a
Default How do I add times that were creted with "=TEXT(A2-A1,"h:mm")"

Thank you. This worked out well.

"Bernard Liengme" wrote:

Replace the formula by =A2-A1 and format [h]:mm (the [] stops 25 becoming 1)
using Format|Cells-custom
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(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!






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
sorting multiple minimum times the swimmer Excel Discussion (Misc queries) 2 December 23rd 05 02:32 AM
Charting and analyzing Times' times data for trends Johnny Excel Discussion (Misc queries) 1 May 5th 05 01:36 AM
Copy from worksheet to another x times Union70 Excel Discussion (Misc queries) 0 March 7th 05 09:03 PM
SUMPRODUCT ON TIMES Bob Phillips Excel Worksheet Functions 1 January 13th 05 05:28 PM
Adding/Averaging Times in Excel JD Excel Discussion (Misc queries) 2 January 5th 05 05:07 PM


All times are GMT +1. The time now is 03:27 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017