Converting Hours into Days

[sanshah01]

Hi,

I have a number of task listed. For each task a certain number of hours
have been assigned. The input of hours is done by Time(H,M,S) formula
and formatted as [h]:mm:ss.

After adding up the total hours for all the task, I would like to
convert it into mandays. Is there any formula or method to do so.

It is assumed that one manday/working day is of 8 hours.

For eg. 96 hours 45 minutes is to be converted to 12.093 days.

How do I convert with a formula since the hours are subject to change
and hence I need the Mandays depending on the total hours.

Regards
Sandip.

 

[Dave Peterson]

Multiply by 24 and divide by 8 and format as General.

=A1*24/8
or just
=A1*3
(still formatted as general)

Hi,

I have a number of task listed. For each task a certain number of hours
have been assigned. The input of hours is done by Time(H,M,S) formula
and formatted as [h]:mm:ss.

After adding up the total hours for all the task, I would like to
convert it into mandays. Is there any formula or method to do so.

It is assumed that one manday/working day is of 8 hours.

For eg. 96 hours 45 minutes is to be converted to 12.093 days.

How do I convert with a formula since the hours are subject to change
and hence I need the Mandays depending on the total hours.

Regards
Sandip.

 

[Ron Rosenfeld]

Hi,

I have a number of task listed. For each task a certain number of hours
have been assigned. The input of hours is done by Time(H,M,S) formula
and formatted as [h]:mm:ss.

After adding up the total hours for all the task, I would like to
convert it into mandays. Is there any formula or method to do so.

It is assumed that one manday/working day is of 8 hours.

For eg. 96 hours 45 minutes is to be converted to 12.093 days.

How do I convert with a formula since the hours are subject to change
and hence I need the Mandays depending on the total hours.

Regards
Sandip.

Time is stored as fractions of a day, so:

Mandays = ur_time * 24 / 8 or
Mandays = ur_time * 3

Format the result as General or Number with an appropriate amount of decimals.


--ron

 

[workaholic]

Hi,

I use something similar:-
="Total Man Time "&FLOOR(SUM(B2:B65536)*3,1)&" Days and
"&TEXT(SUM(SUM(B2:B439),-TIME(8,0,0)*FLOOR(SUM(B2:B439)*3,1)),"h:mm:ss")

Which displays:-
Total Man Time 122 Days and 1:37:22

and cell format is general.

Regards

 

[R.VENKATARAMAN]

96 hours cannot be 12 days but only 4 days

however try this solution(solution from these newsgroups)


a1 96:45:00
a2 =a1*24
reformat a2 as general and NOT time
it will be 96.75
a3 a2/24
it will be 4.03125 days;.

===========

Hi,

I use something similar:-
="Total Man Time "&FLOOR(SUM(B2:B65536)*3,1)&" Days and
"&TEXT(SUM(SUM(B2:B439),-TIME(8,0,0)*FLOOR(SUM(B2:B439)*3,1)),"h:mm:ss")

Which displays:-
Total Man Time 122 Days and 1:37:22

and cell format is general.

Regards

Hi,

I have a number of task listed. For each task a certain number of hours
have been assigned. The input of hours is done by Time(H,M,S) formula
and formatted as [h]:mm:ss.

After adding up the total hours for all the task, I would like to
convert it into mandays. Is there any formula or method to do so.

It is assumed that one manday/working day is of 8 hours.

For eg. 96 hours 45 minutes is to be converted to 12.093 days.

How do I convert with a formula since the hours are subject to change
and hence I need the Mandays depending on the total hours.

Regards
Sandip.

 

[Ron Rosenfeld]

96 hours cannot be 12 days but only 4 days

Perhaps you should reread the original poster's message, which you quoted in
your response.


--ron

 

[workaholic]

Well said Ron

Perhaps you should reread the original poster's message, which you quoted in
your response.


--ron

 

[R.VENKATARAMAN]

sorry apologise profusely for not reading thoroughly.