View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Convert hrs to date but 1day=7.5hrs not 24hrs

How do I convert 81:45 hrs to 10 days & 00:15..

Shouldn't that be 10 days 6:45?

See your other post.

--
Biff
Microsoft Excel MVP


wrote in message
...
Hi there,

How do I convert 81:45 hrs to 10 days & 00:15.. I need to calculate
as 1day= 07:30 hrs not 24:00 hrs


Thanks in advance,

Dzoker