Adding hours and minutes

Hi everybody,

In one column I have the number of hours 2, 3, etc
In another the number of minutes 14, 16, etc
How can I get the number of total of number of hours work

At the moment I have divided the minutes by 60 and add them to the hours and it is showing 2.62, 2.63, etc
Is there anther way to show this info, more professional eg 2 H 23 Min and that I can create a conditioning formatting for those ie under 30 minutes?

Many thanks,
j

With hours in Col_A and minutes in Col_B
either of these regular formulas will return the total time
formatted as "00 h 00 min":

Please Login or Register  to view this content.

Alternatively, you could use either SUMPRODUCT section and use a custom
number format of: h \h m \m\i\n

Is that something you can work with?