Excel
 

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

Excel
 

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


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=568412

Excel
 

This was a great help.

Thanks,
MF.

"VBA Noob" wrote:


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


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=568412