Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Hello, i've got a little problem with time.
A2 = 22:00 ( start time ) b2 = 7:00 ( finish time ) c2 = 1:30 ( breaks ) d2 = 7:30 ( hours worked less breaks ) e2 = hours worked between 6pm and midnight ( formula required please ) f2 = hours worked between midnight and 6am ( formula required please ) g2 = hours worked between 6am and 6pm ( formula required please ) i've looked on the forums and found out how to workout how to calculate d2 but need formulas for e2,f2,g2 i'm sure this will be easy to someone but i'm clueless. thanks for any help given |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
IF statement to calculate time usage in specific time bands | Excel Worksheet Functions | |||
how to calculate time start & time finish in quarter hour | Excel Discussion (Misc queries) | |||
HOW DO I CALCULATE TIME IN A TIME SHEET FOR EXCEL | New Users to Excel | |||
i need to calculate the total time from a start time to and end t. | Excel Discussion (Misc queries) | |||
How do I set up a formula on a time sheet to calculate time in 1/. | Excel Discussion (Misc queries) |