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
=MAX(B17-"18:00:00",0)*24
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Perhaps:
=MAX(0,A1-"18:00:00")
where A1 contains the finish time. Format this formula cell as time ie hh:mm.
Richard
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
Have a look here
http://www.cpearson.com/excel/datearith.htm#AddingTimes
Posting Permissions
Reply With Quote
