Formatting Numbers as Minutes
 

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

Formatting Numbers as Minutes
 

A1 = 90
B1 you should have the following formula =A1/(24*60)

Format cell B1: Format/Cells/Custom/hh:mm


--
Portuga
------------------------------------------------------------------------
Portuga's Profile: http://www.excelforum.com/member.php...fo&userid=6385
View this thread: http://www.excelforum.com/showthread...hreadid=522704

Formatting Numbers as Minutes
 

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

Formatting Numbers as Minutes
 

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
--
Gary''s Student


"LPS" wrote:

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