Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Calculating Time
I am trying to calculate the total hours attended when I type in the
hours for the day. For example: 7:30 am is in Time In and 4:00 pm is in Time Out Column. Now I need to get the total hours, which would be 8.5 hours or 8 1/2 hours. How do I do this? Thank you in advance. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Calculating Time
Debbie
If the time in is in A1 and B1 has the time out then in C1 enter =B1-A1 This will return 8:30. Is this OK? (Make sure all cells are formatted to time) -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "Debbie" wrote in message ups.com... I am trying to calculate the total hours attended when I type in the hours for the day. For example: 7:30 am is in Time In and 4:00 pm is in Time Out Column. Now I need to get the total hours, which would be 8.5 hours or 8 1/2 hours. How do I do this? Thank you in advance. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Calculating Time
One way:
A1: 7:30 am B1: 4:00 pm C1: =B1-A1 Format C1 as a time. If the times may span midnight, use C1: =MOD(B1-A1,1) In article . com, "Debbie" wrote: I am trying to calculate the total hours attended when I type in the hours for the day. For example: 7:30 am is in Time In and 4:00 pm is in Time Out Column. Now I need to get the total hours, which would be 8.5 hours or 8 1/2 hours. How do I do this? Thank you in advance. |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Calculating Time
If you need 8.5 rather than 8:30:
C1: =(B1-A1)*24 format as General In article , JE McGimpsey wrote: One way: A1: 7:30 am B1: 4:00 pm C1: =B1-A1 Format C1 as a time. If the times may span midnight, use C1: =MOD(B1-A1,1) In article . com, "Debbie" wrote: I am trying to calculate the total hours attended when I type in the hours for the day. For example: 7:30 am is in Time In and 4:00 pm is in Time Out Column. Now I need to get the total hours, which would be 8.5 hours or 8 1/2 hours. How do I do this? Thank you in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating time and negative time | Excel Worksheet Functions | |||
calculating timesheet, time-in/time-out = total hours & minutes, . | Excel Worksheet Functions | |||
Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
Calculating Time | Excel Discussion (Misc queries) | |||
Calculating effective time from start/end date+time | Excel Worksheet Functions |