Excel

[Guest]

I have a spreadsheet that calculates hours and minutes. I know need to
insert a column to give me a total hours and minutes. How do I do this? I
have tried the @sum function but is not correct.

Thanks,
Miriam

 

[VBA Noob]

Say you want to total

A1 18:00
B1 07:00


enter this in C1 =SUM(A1:A2) and format cell as [h]:mm

VBA Noob

 

[Guest]

This was a great help.

Thanks,
MF.