Time Elapsed

[BENSON]

I am working on a shift roster and need help with a formula to determine the following:
A person starts work at 15:00 hrs (3pm) and works untill 23:00 (11pm ),all hours worked after 18:00 ( 6pm) attract a night shift allowance.I can do the formula to give me total Hrs worked but not the formula to tell me how many Hrs worked after 18:00 (6pm)

Any pointers
Thks

[Bob Phillips]

=MAX(B17-"18:00:00",0)*24

[RichardSchollar]

Perhaps:

=MAX(0,A1-"18:00:00")

where A1 contains the finish time. Format this formula cell as time ie hh:mm.

Richard

[stanl]

does this help?

http://www.mvps.org/dmcritchie/excel/elapsed.htm

without knowing how you have your times set up, it is difficult to give a direct answer. .02

[sujittalukde]

Have a look here
http://www.cpearson.com/excel/datearith.htm#AddingTimes