How to calculate Total Units * time per unit

All,

I'm having trouble calculating total units * time per unit. I'm using the following formula: =SUM(total units*time per unit).

Using the above formula and the following values:

2240 units * 4:05 hrs my result is 2:40 when it should be 9000+ hours.

Background:

Total units -cell format: number and the value is hard coded

Time per unit - cell format: time 13:30 and is calculated by =SUM(B11:B13)/1440.

Any suggestions would be appreciated.

Thanks, SDrob

You are using the correct formula (although SUM function does nothing here, =total units*time per unit is sufficient)

but you need to format the result cell differently. You are using a format of h:mm which never shows a result larger than 24:00. To correctly display "elapsed time", i.e. anything over 24 hours, custom format your result cell as

[h]:mm