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
|