I currently have a start time cell and a finish time cell. What i need to do in another cell called Overtime is - if the finish time cell has gone over 16:00 show how many hours have been claimed.
If possible i would like it to show 2.5 hours for 2 1/2 hours etc....
JonesZoid
Last edited by JonesZoid; 03-09-2010 at 07:11 PM.
If I understand your question, the start time doesn't matter, it's just the hours past 16:00.
=MAX(0, B1 - "16:00") * 24 and format as Number.
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks