divide hours

[emorocks83]

hi again!

I am having a small issue, i want to divide 40 hours in 6 (40/6) and i need to display it in hours and minutes.

also aproximately would be 6hrs 3/4, i also need to display it in hours and minutes and not as a fraction, i would also like to multiply, divide, sum, substract etc.

hope somebody can help me

thanks a lot

[duane]

is this what you had in mind?

=TIME(40/6,MOD(40,6)*10,0)

results in 06:40:00 if formatted as time, hh:mm:ss

[emorocks83]

great it helped me a alot
thanks!