| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
time calculations
I need help with a calculating two time periods of a work day
B2 = day of the month B3 = Time in such as 8:00 AM B4 = Time out such as 1:30 PM B5 = Time in such as 3:00 PM B6= Time out such as 5:00 PM I would like B7 to figure out what the total time in hours for this particular day of work. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
time calculations
Check out the Excel MVPs site:
http://www.mvps.org/dmcritchie/excel/datetime.htm#core -- Please remember to indicate when the post is answered so others can benefit from it later. "cboczarski" wrote: I need help with a calculating two time periods of a work day B2 = day of the month B3 = Time in such as 8:00 AM B4 = Time out such as 1:30 PM B5 = Time in such as 3:00 PM B6= Time out such as 5:00 PM I would like B7 to figure out what the total time in hours for this particular day of work. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
time calculations
You want:
=((b4-b3)+(b6-b5))*24 Format as number. Regards, Fred "cboczarski" wrote in message ... I need help with a calculating two time periods of a work day B2 = day of the month B3 = Time in such as 8:00 AM B4 = Time out such as 1:30 PM B5 = Time in such as 3:00 PM B6= Time out such as 5:00 PM I would like B7 to figure out what the total time in hours for this particular day of work. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time calculations for Scheduled vs Actual Employee Time and Wages | Excel Discussion (Misc queries) | |||
| Time calculations for Scheduled Time vs. Actual Time Worked | Excel Discussion (Misc queries) | |||
| Time calculations for Scheduled vs Actual Employee Time and Wages | Excel Discussion (Misc queries) | |||
| Time difference calculations, daylight savings time, Excel | Excel Discussion (Misc queries) | |||
| convert time imported as text to time format for calculations | Excel Worksheet Functions | |||
Linear Mode
