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
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