Adding Number to Time Format hh:mm:ss

[Firasath]

Hi,

I have a report where I'm getting number of days in a column in General Format and in another column Hours in hh:mm:ss time format. I would like to add it and get the result in total hours.

Suppose in days column, it is showing 3 and in second column the data is 08:00:00 in hh:mm:ss format.

The result of it I should get is 3*24 + 8 = 80 Hours.

Kindly advise.

 

[FormR]

You can simply add them.

Custom format the cell containing the formula as "[h]:mm"

Excel Workbook
	A	B	C
1	Days	Time	Total
2	3	08:00	80:00
Sheet1

 

[Firasath]

Thanks a lot. I was trying the same method but did not change the mentioned format in column C and got confused.