If you enter the minutes as

a1: 0:45
b1: 0:55

if C1 is formatted as hh:mm

then

=sum(A1:B1) in C1 would display

c1: 01:40

If the minutes are

A1: 45
B1: 55

c1: =TRUNC(SUM(A1:B1)/60) & " hrs " & MOD(SUM(A1:B1),60) & " Min"

--
Regards,
Tom Ogilvy


Is there any way to format numbers so that Excel recognised them as minutes
so that when they are added together, if the sum is over 60, they get
converted to hours, e.g. a total of 90 would convert to 1.5 hours?
--
LPS