Thread: dates to hours
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Champ Champ is offline
external usenet poster
 
Posts: 37
Default dates to hours

I have two times in my spreadsheet.
I have a job that has a start time that begins at 07:00 and ended the job
3-days later at 23:47.
The real lapsed time is days from start to finish, however I keep getting a
(-) negative, ###### answer.
Does anyone know how to eqaute this into hours, ie: 88:47? (positive hours)

Thanks,
Champ