hours into working days

bam12

Well-known Member
Joined
Dec 6, 2004
Messages
983
if i ahve 66.5 hours, what formula would i use to show it in work days
with work says being hours hours long

so that it would show 8 days 2 1/2 hours
 

Some videos you may like

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

jbfrank

Active Member
Joined
Oct 13, 2003
Messages
290
I'm not sure of the formatting of your information, but let's assume you have 66.5 in cell A1. In cell B1, enter the following =A1/8.

Right click on cell B1 and change the format to Custom. In the "Type:" field at the top, enter dd:hh:mm and click OK.

You should be left with 08:07:30, which is 8 Days, 7 hours, and 30 minutes.
 

UPN

Board Regular
Joined
May 14, 2006
Messages
138
incorrect

8 times 8 is 64

subtract from 66.5 leaves 2 1/2 hours not 7 hours .30 minutes
 

UPN

Board Regular
Joined
May 14, 2006
Messages
138
sorry about first message should have been 8 hours is a day
 

daniels012

Well-known Member
Joined
Jan 13, 2005
Messages
5,219

ADVERTISEMENT

This should work for most total hours:
Book1
FGHI
1166.5
12
13=ROUND(F11/8,0)=MOD(F11,8)
14
158Days2.5hours
Sheet1




Michael
 

UPN

Board Regular
Joined
May 14, 2006
Messages
138

ADVERTISEMENT

problem

Daniels012

Looks like there is a problem with formula, if you put 100.5 hours in here it should be 12 days 4.5 hours

it is coming up 13 days 4.5 hours
 

Watch MrExcel Video

Forum statistics

Threads
1,114,388
Messages
5,547,661
Members
410,805
Latest member
Ginoji
Top