PDA

View Full Version : Solved: Converting Minutes Into Hours



Mattster2020
10-29-2009, 03:40 AM
Morning All,

I have a value in cell E7 that is based on minutes, for example 150.

In cell F7 I am using the formula =TEXT(E7/60/24,"hh:mm") to show minutes in correct time format, i.e 02:30.

This is fine and works well, apart from when the minutes exceed 24:00, excel will roll back to 00:00. for example 1695 minutes is shown as 04:15.

Is there anyway to get round this problem? Is there a way for Excel to continue showing time format past 24:00?

Any help would be appriecated.

Regards,

Matt

Mattster2020
10-29-2009, 03:49 AM
I have solved the problem, simply enclose square brackets around hour format, as per below:

=TEXT(E7/60/24,"[hh]:mm")