Time Addition

[rcampisi1976]

Hi All:

Below is an example of how time off is exported from the software we use. The first item from 2/1 is 3 hours and 4 minutes. The one from 3/18 would be 2 hours and 45 minutes.

Is there a way to add these up with-out calculating them manually? Or is there a formula I can use to calculate quickly?

Thanks in advance... You guys are amazing!!

DATE TAKEN	AMOUNT HOURS TAKEN
2/1/2016	3:04
2/8/2016	3:00
2/15/2016	3:00
3/18/2016	2:45
3/21/2016	4:00
3/28/2016	3:00
4/1/2016	3:00
4/4/2016	4:00

 

[BKrukowski]

Highlight the column
RightClick
Format Cells
Custom
h:mm

They will then add up properlt