hrs:mins exceed 24hrs

[scoobyblue]

For ease of inputting I have a number of columns where I input hrs as a decimal and mins as decimal, to save typing 0:45 for 45 mins I just input 45 and for hours just the number without the colon.
I am trying to total all of these by converting the sum of all the hours & minutes to a time format (that doesn't show 00:00 if the total is 24hrs exactly, but would show 24:00). For example, if the total hours = 28, and the total minutes = 130, I would like a separate cell to convert this into the time format and read 30:10.

Many thanks for your help,
scoobyblue

 

[VoG]

Try like this - C1 formatted as Custom [h]:mm

Excel Workbook
	A	B	C
1	28	130	30:10
Sheet2

 

[RoryA]

Assuming you already have a time conversion formula, just format the cell as [hh]:mm

 

[scoobyblue]

Try like this - C1 formatted as Custom [h]:mm

Excel Workbook
	A	B	C
1	28	130	30:10
Sheet2

Thanks, just what I was looking for.