Formatting Numbers as Minutes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
A1 = 90
B1 you should have the following formula =A1/(24*60)

Format cell B1: Format/Cells/Custom/hh:mm
 
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"
 
There are two ways:

if A1 contains 90, then in B1 put:
=A1/24/60 and format as time and you will see:
1:30:00 AM


if A1 contains 90, then in B1 put:
=A1/60 and format as general and you will see:
1.5
 
Back
Top