Converting Millitary Time to Hours worked and OT hours
What I'm trying to do is. Take 700 start time to an end time of 1700 then I
need it to convert it to hours worked then the next cell show hours no more
then 8 in the next cell any thing over the 8 hours. Start time would be one
cell, End time is one cell, Total Hours is one sell, Hours no more them 8 is
one cell, overtime hours is one cell. Then I have to Multiply the 8 hours in
the next cell and then the ot hour in the next cell. Any help would be fine.
Thanks in advance
|