Hi there - I hope someone can help a novice please!
I've tried searching but don't understand most of the answers so apologies
if this has already been answered

I have a spreadsheet which needs to display working hours per week in both
decimal and in hours and minutes. What I'm doing is taking the decimal result
and converting it to hours and minutes using this formula
=TEXT(G28/24,"h:mm") which works a treat ... unless the hours are more than
24

I'm sure there must be a simple solution - but I'm too simple to figure it
out - please help !

Rob