Formula to show non decimal hours
 

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

Formula to show non decimal hours
 

If you don't want to use : try this formula

=TEXT(TEXT(A1*100,"0\:00")+TEXT(B1*100,"0\:00"),"h h.mm")+0

format as number



"daddylonglegs" wrote:

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