View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dzoker Dzoker is offline
external usenet poster
 
Posts: 1
Default Convert Time to Days

Hi there,

I need to convert 81:30 hrs to 10 days & 06:30 hrs. All formulas work
as 1day=24:00hrs....but I need 1day=07:30hrs..What I'm doing is time
sheet for my CompTime and i need to calculate - total CompTime Hrs =
How many working days...1working day = 07:30Hrs...

How can I do this...Any idea..Please help!!!


Thanks in advance,
D.