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

--
billcar200
-----------------------------------------------------------------------
billcar2005's Profile: http://www.excelforum.com/member.php...fo&userid=3511
View this thread: http://www.excelforum.com/showthread.php?threadid=54869

If A1 contains 54:53:20 then
=A1*24/8 will yield 6.861111111

--
Gary's Student


"billcar2005" wrote:

>
> Hi
> I have a time of 54:53:20 Hrs:mins:secs . I am trying to change
> this to days but not 24hr days. I need to work out how many 8 hr
> working days are in this.
> Liam
>
>
> --
> billcar2005
> ------------------------------------------------------------------------
> billcar2005's Profile: http://www.excelforum.com/member.php...o&userid=35113
> View this thread: http://www.excelforum.com/showthread...hreadid=548690
>
>

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
> I have a time of 54:53:20 Hrs:mins:secs . I am trying to change
> this to days but not 24hr days. I need to work out how many 8 hr
> working days are in this.
> Liam
>
>
> --
> billcar2005
> ------------------------------------------------------------------------
> billcar2005's Profile: http://www.excelforum.com/member.php...o&userid=35113
> View this thread: http://www.excelforum.com/showthread...hreadid=548690
>
>

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


--
billcar2005
------------------------------------------------------------------------
billcar2005's Profile: http://www.excelforum.com/member.php...o&userid=35113
View this thread: http://www.excelforum.com/showthread...hreadid=548690

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" <(E-Mail Removed)>
wrote in message
news:(E-Mail Removed)...
>
> 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
>
>
> --
> billcar2005
> ------------------------------------------------------------------------
> billcar2005's Profile:
> http://www.excelforum.com/member.php...o&userid=35113
> View this thread: http://www.excelforum.com/showthread...hreadid=548690
>