Sum up hours

[Kjaer]

Hi

I'm trying to sum up a number of cells containing work hours (in time format) per day but when the total exceeds 24 hours it "starts over". So how do I get it to sum up e.g.

10:30
8:00
10:45
9:15
to 38:30?

I can get it to return 38,50 but I can't get it to keep the time format.

Can anyone help me :-)?

Thanks,
Kjaer

[VBA Noob]

Format cell with answer as

[h]:mm

VBA Noob

[Kjaer]

Perfect
Thanks

[VBA Noob]

Glad it helped

VBA Noob