Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
Exporting From Quickbooks-not formatting numbers | Excel Discussion (Misc queries) | |||
Conditional Formatting on Whole Numbers? | Excel Worksheet Functions | |||
Count and Sum Total occurrances of two specific numbers | Excel Worksheet Functions | |||
Converting Numbers to Text properly | Excel Discussion (Misc queries) |