Thread: Convert hrs to date but 1day=7.5hrs not 24hrs
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] VladoF@gmail.com is offline
external usenet poster
  
Posts: 1
Default 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
Reply With QuoteReply With Quote