calcutating days

  • Thread starter Thread starter billcar2005
  • Start date Start date
B

billcar2005

Hi
I have a time of 54:53:20 Hrs:mins:secs . I am trying to chang
this to days but not 24hr days. I need to work out how many 8 h
working days are in this.
Lia
 
imagine this figure is on the b2

=b2/8*24

so the answer will be 6,8611 work days (remember to format as general)

hope this helps
regards from Brazil
Marcelo

"billcar2005" escreveu:
 
Hi
Thanks for the answers. if I do this, then format 6.8611 to time.
"Days, hours, minutes and seconds" , I get this 06 20:40:00. Should I
not get this 06 06:53:20 ( 6 days - 6 x 8 hour days = 48hours, 6 hours
- 54 hours minus 48 hours=6, 53 minutes and 20 seconds). To format the
cell I put in custom number - dd hh:mm:ss . Is this right.
Liam
 
6.8611 is equal to 6 day 20 hours 39 minutes and 59 seconds, so if that is
incorrect then the 6.8611 must be incorrect

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"billcar2005" <[email protected]>
wrote in message
news:[email protected]...
 
Back
Top