View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Josh Josh is offline
external usenet poster
 
Posts: 103
Default help creating a time function

Hello,
I am trying to create a time function that will look at a typical day and
add the hours. Then show how many hours after 8 is overtime. I have the
first part created, but how can I write a formula that will look at say 12:45
hours and tell me 4:45 of it is overtime? Please help!!

Thanks!!!