Convert hrs to date but 1day=7.5hrs not 24hrs
 

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

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