Formatting Time

[rhombus4]

Currently add up times which then calcualte a formula, however I want to also show the total time as Hours and minutes. each time is hours and minutes, however below it will show as 4.8 which is 4hours 80 mins how do i get it to show as 5 hrs 20 minse.g. have times as 1.1 1.1 1.25 1.35

 

[T. Valko]

Currently add up times which then calcualte a formula, however I want to also show the total time as Hours and minutes. each time is hours and minutes, however below it will show as 4.8 which is 4hours 80 mins how do i get it to show as 5 hrs 20 minse.g. have times as 1.1 1.1 1.25 1.35

Why don't you just "go with the flow" and enter the times as TIMES?

It will be much easier!

 

[barry houdini]

Which version of Excel are you using? In Excel 2007 or later versions you can use this formula, assuming data in A2:A10

=SUMPRODUCT(DOLLARDE(A2:A10+0,60)+0)/24

format result cell as [h]:mm

 

[rhombus4]

using excel 2003, reason havent entered as times because alot of data from old spreadheets which is linked which also calcluates some days and other stuff

 

[barry houdini]

OK, In 2003 try this formula

=SUMPRODUCT(A2:A10+MOD(A2:A10,1)*2/3)/24

format as before

 

[rhombus4]

OK, In 2003 try this formula

=SUMPRODUCT(A2:A10+MOD(A2:A10,1)*2/3)/24

format as before

Thanks, above worked great

 

[rhombus4]

OK, In 2003 try this formula

=SUMPRODUCT(A2:A10+MOD(A2:A10,1)*2/3)/24

format as before

1 quick thing, If I have a list which have been formatted already i.e. showing 5:20 how do I format it back so that it shows the old way for my previous calculations i.e.4.8