converting minutes into hours > 24 Hours

  • Thread starter Thread starter VINAY DALMIA
  • Start date Start date
V

VINAY DALMIA

am not able to convert a number greater than 24 into h:m:s
I use the formula =(H5/24;"hh:mm:ss") but this only works up to 24.

When I try this with 27.50, the result is 03:30:00 because the hours start
counting again from 0 after they have reached 24.

What can I do to get 27:30:00 as a result?
 
I use the formula =(H5/24;"hh:mm:ss")

That's not a valid formula. Maybe you use this: =H5/24

Try formatting the cell as [hh]:mm:ss

That'll keep the hours from rolling over after 24.
 
Back
Top