View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Djbaker70 Djbaker70 is offline
external usenet poster
 
Posts: 7
Default 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