andreasmall's blog
Excel Formula Help
Submitted by andreasmall on 11 April, 2012 - 09:55I am struggling to work out the correct formula to work out the following problem: I am trying to work out how many day hours and how many night hours make up one shift. E.g
Start time 1pm (date 8/7/12)
End time 1am (date 9/7/12)
Shift Length = 12 hours
Day Hours (Day hours are classed between:7am - Midnight) 6 hours
Night Hours (Night hours are classed between:Midnight - 7am) 6 hours
A1 = Start time
B1 = End time
C1 = Day Hours
D1 = Night Hours
E1 = Shift Length
Please help
x
»
- 1 comment
- 4646 reads
Recent comments
5 years 34 weeks ago
6 years 20 weeks ago
6 years 32 weeks ago
6 years 35 weeks ago
6 years 36 weeks ago
6 years 42 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago