Ideally input in hours format, i.e. with a colon ":", e.g. if A1 is 1:01 and
B1 is 0:59

then the formula

=A1+B1 will give you 2:00

"colgar65" wrote:

How do I get a formula to add up over the hour mark not using :

IE

1.01 + 0.59 = 1.01 hours not as adds up to 1.61