# Formula to convert 24 hour day to 8 hour (working) day?

1. ## Formula to convert 24 hour day to 8 hour (working) day?

Hello

Is it possible to take data in format dd:hh:mm and convert to working days - ie. 8 hour days?

For example:

02:12:15 (60 hours and 15 minutes .. or 3615 minutes)

to be converted to:

07:04:15 (7 working days: 4 hours: 15 minutes)

K

2. ## Re: Formula to convert 24 hour day to 8 hour (working) day?

With your datum in cell A1 in format dd:hh:mm, use:

Formula:
`Please Login or Register  to view this content.`

3. ## Re: Formula to convert 24 hour day to 8 hour (working) day?

hi K. another way:
=INT(A2*24/8)+MOD(A2*24,8)/24

4. ## Re: Formula to convert 24 hour day to 8 hour (working) day?

Thank you - both options were successful for my purpose!

5. ## Re: Formula to convert 24 hour day to 8 hour (working) day?

Neither are working correctly for me......

The first shows as an extra day whilst the second is a day under.

I've had to alter the formula slightly as i need it to show as 7 1/2 hour days rather than 8.

Any suggestions?

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1