| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time calculus in Excel 2000
Greetings. I have recently been handed a project dealing with process times.
I have one set of numbers as seconds (ss.ssssssss) and one as a decimal version of minutes (.91 m). What process do I need to know to convert these numbers into a workable format. I'm hoping to have them as mm:ss.ss and then doing basic math with the results. Thanks in advacne. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Time calculus in Excel 2000
See http://www.cpearson.com/excel/datetime.htm
Let us know if you still need support. "First Aid Computing" wrote: Greetings. I have recently been handed a project dealing with process times. I have one set of numbers as seconds (ss.ssssssss) and one as a decimal version of minutes (.91 m). What process do I need to know to convert these numbers into a workable format. I'm hoping to have them as mm:ss.ss and then doing basic math with the results. Thanks in advacne. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Time calculus in Excel 2000
In Excel, Time is the fraction of a day that has passed for the given time
(for example, 3:00 AM is 3/24 (or 0.125) of a 24-hour day. To convert seconds (assumed to be in A1), use this... =A1/86400 To convert minutes (assumed to be in B1), use this... ==B1/1440 Custom Format the cells using this pattern... mm.ss.00 in the Type field. Note: The 86400 comes from multiplying 24 (hours in a day) times 60 (minutes in an hour) * 60 (seconds in a minute); the 1440 comes from multiplying 24 (hours in a day) times 60 (minutes in an hour). -- Rick (MVP - Excel) "Sheeloo" <="to" & CHAR(95) & "sheeloo" & CHAR(64) & "hotmail.com" wrote in message ... See http://www.cpearson.com/excel/datetime.htm Let us know if you still need support. "First Aid Computing" wrote: Greetings. I have recently been handed a project dealing with process times. I have one set of numbers as seconds (ss.ssssssss) and one as a decimal version of minutes (.91 m). What process do I need to know to convert these numbers into a workable format. I'm hoping to have them as mm:ss.ss and then doing basic math with the results. Thanks in advacne. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Time calculus in Excel 2000
Sorry... I meant to post my message to the OP.
-- Rick (MVP - Excel) "Rick Rothstein" wrote in message ... In Excel, Time is the fraction of a day that has passed for the given time (for example, 3:00 AM is 3/24 (or 0.125) of a 24-hour day. To convert seconds (assumed to be in A1), use this... =A1/86400 To convert minutes (assumed to be in B1), use this... ==B1/1440 Custom Format the cells using this pattern... mm.ss.00 in the Type field. Note: The 86400 comes from multiplying 24 (hours in a day) times 60 (minutes in an hour) * 60 (seconds in a minute); the 1440 comes from multiplying 24 (hours in a day) times 60 (minutes in an hour). -- Rick (MVP - Excel) "Sheeloo" <="to" & CHAR(95) & "sheeloo" & CHAR(64) & "hotmail.com" wrote in message ... See http://www.cpearson.com/excel/datetime.htm Let us know if you still need support. "First Aid Computing" wrote: Greetings. I have recently been handed a project dealing with process times. I have one set of numbers as seconds (ss.ssssssss) and one as a decimal version of minutes (.91 m). What process do I need to know to convert these numbers into a workable format. I'm hoping to have them as mm:ss.ss and then doing basic math with the results. Thanks in advacne. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Time calculus in Excel 2000
In Excel, Time is the fraction of a day that has passed for the given time
(for example, 3:00 AM is 3/24 (or 0.125) of a 24-hour day. To convert seconds (assumed to be in A1), use this... =A1/86400 To convert minutes (assumed to be in B1), use this... ==B1/1440 Custom Format the cells using this pattern... mm.ss.00 in the Type field. Note: The 86400 comes from multiplying 24 (hours in a day) times 60 (minutes in an hour) * 60 (seconds in a minute); the 1440 comes from multiplying 24 (hours in a day) times 60 (minutes in an hour). -- Rick (MVP - Excel) "First Aid Computing" <First Aid wrote in message ... Greetings. I have recently been handed a project dealing with process times. I have one set of numbers as seconds (ss.ssssssss) and one as a decimal version of minutes (.91 m). What process do I need to know to convert these numbers into a workable format. I'm hoping to have them as mm:ss.ss and then doing basic math with the results. Thanks in advacne. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Time calculus in Excel 2000
This works well. Now to figure out how to have it display negative seconds
as - instead of ############. "Rick Rothstein" wrote: In Excel, Time is the fraction of a day that has passed for the given time (for example, 3:00 AM is 3/24 (or 0.125) of a 24-hour day. To convert seconds (assumed to be in A1), use this... =A1/86400 To convert minutes (assumed to be in B1), use this... ==B1/1440 Custom Format the cells using this pattern... mm.ss.00 in the Type field. Note: The 86400 comes from multiplying 24 (hours in a day) times 60 (minutes in an hour) * 60 (seconds in a minute); the 1440 comes from multiplying 24 (hours in a day) times 60 (minutes in an hour). -- Rick (MVP - Excel) "First Aid Computing" <First Aid wrote in message ... Greetings. I have recently been handed a project dealing with process times. I have one set of numbers as seconds (ss.ssssssss) and one as a decimal version of minutes (.91 m). What process do I need to know to convert these numbers into a workable format. I'm hoping to have them as mm:ss.ss and then doing basic math with the results. Thanks in advacne. |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Time calculus in Excel 2000
Tools/ Options/ Calculation: 1904 date system
but beware if you need to transfer data to and fro between 1900 and 1904 date systems. -- David Biddulph "First Aid Computing" wrote in message ... This works well. Now to figure out how to have it display negative seconds as - instead of ############. "Rick Rothstein" wrote: In Excel, Time is the fraction of a day that has passed for the given time (for example, 3:00 AM is 3/24 (or 0.125) of a 24-hour day. To convert seconds (assumed to be in A1), use this... =A1/86400 To convert minutes (assumed to be in B1), use this... ==B1/1440 Custom Format the cells using this pattern... mm.ss.00 in the Type field. Note: The 86400 comes from multiplying 24 (hours in a day) times 60 (minutes in an hour) * 60 (seconds in a minute); the 1440 comes from multiplying 24 (hours in a day) times 60 (minutes in an hour). -- Rick (MVP - Excel) "First Aid Computing" <First Aid wrote in message ... Greetings. I have recently been handed a project dealing with process times. I have one set of numbers as seconds (ss.ssssssss) and one as a decimal version of minutes (.91 m). What process do I need to know to convert these numbers into a workable format. I'm hoping to have them as mm:ss.ss and then doing basic math with the results. Thanks in advacne. |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Time calculus in Excel 2000
Afraid that the 1904 seems to do nothing. I just want to subtract two time
amounts and have it display a negative and the time. Eg. 25.3s - 26.3s = -1.0s. Right now it shows ############ or if I reformat to general, -1.15741-05. "David Biddulph" wrote: Tools/ Options/ Calculation: 1904 date system but beware if you need to transfer data to and fro between 1900 and 1904 date systems. -- David Biddulph "First Aid Computing" wrote in message ... This works well. Now to figure out how to have it display negative seconds as - instead of ############. "Rick Rothstein" wrote: In Excel, Time is the fraction of a day that has passed for the given time (for example, 3:00 AM is 3/24 (or 0.125) of a 24-hour day. To convert seconds (assumed to be in A1), use this... =A1/86400 To convert minutes (assumed to be in B1), use this... ==B1/1440 Custom Format the cells using this pattern... mm.ss.00 in the Type field. Note: The 86400 comes from multiplying 24 (hours in a day) times 60 (minutes in an hour) * 60 (seconds in a minute); the 1440 comes from multiplying 24 (hours in a day) times 60 (minutes in an hour). -- Rick (MVP - Excel) "First Aid Computing" <First Aid wrote in message ... Greetings. I have recently been handed a project dealing with process times. I have one set of numbers as seconds (ss.ssssssss) and one as a decimal version of minutes (.91 m). What process do I need to know to convert these numbers into a workable format. I'm hoping to have them as mm:ss.ss and then doing basic math with the results. Thanks in advacne. |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Time calculus in Excel 2000
I'd try it once more.
First Aid Computing wrote: Afraid that the 1904 seems to do nothing. I just want to subtract two time amounts and have it display a negative and the time. Eg. 25.3s - 26.3s = -1.0s. Right now it shows ############ or if I reformat to general, -1.15741-05. "David Biddulph" wrote: Tools/ Options/ Calculation: 1904 date system but beware if you need to transfer data to and fro between 1900 and 1904 date systems. -- David Biddulph "First Aid Computing" wrote in message ... This works well. Now to figure out how to have it display negative seconds as - instead of ############. "Rick Rothstein" wrote: In Excel, Time is the fraction of a day that has passed for the given time (for example, 3:00 AM is 3/24 (or 0.125) of a 24-hour day. To convert seconds (assumed to be in A1), use this... =A1/86400 To convert minutes (assumed to be in B1), use this... ==B1/1440 Custom Format the cells using this pattern... mm.ss.00 in the Type field. Note: The 86400 comes from multiplying 24 (hours in a day) times 60 (minutes in an hour) * 60 (seconds in a minute); the 1440 comes from multiplying 24 (hours in a day) times 60 (minutes in an hour). -- Rick (MVP - Excel) "First Aid Computing" <First Aid wrote in message ... Greetings. I have recently been handed a project dealing with process times. I have one set of numbers as seconds (ss.ssssssss) and one as a decimal version of minutes (.91 m). What process do I need to know to convert these numbers into a workable format. I'm hoping to have them as mm:ss.ss and then doing basic math with the results. Thanks in advacne. -- Dave Peterson |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Time calculus in Excel 2000
Well, I'll be horn-swaggled. It decided to work tonight. It didn't at
first, so I changed the number format then changed it back and it worked on the entire sheet now. Thank you very much. "Dave Peterson" wrote: I'd try it once more. First Aid Computing wrote: Afraid that the 1904 seems to do nothing. I just want to subtract two time amounts and have it display a negative and the time. Eg. 25.3s - 26.3s = -1.0s. Right now it shows ############ or if I reformat to general, -1.15741-05. "David Biddulph" wrote: Tools/ Options/ Calculation: 1904 date system but beware if you need to transfer data to and fro between 1900 and 1904 date systems. -- David Biddulph "First Aid Computing" wrote in message ... This works well. Now to figure out how to have it display negative seconds as - instead of ############. "Rick Rothstein" wrote: In Excel, Time is the fraction of a day that has passed for the given time (for example, 3:00 AM is 3/24 (or 0.125) of a 24-hour day. To convert seconds (assumed to be in A1), use this... =A1/86400 To convert minutes (assumed to be in B1), use this... ==B1/1440 Custom Format the cells using this pattern... mm.ss.00 in the Type field. Note: The 86400 comes from multiplying 24 (hours in a day) times 60 (minutes in an hour) * 60 (seconds in a minute); the 1440 comes from multiplying 24 (hours in a day) times 60 (minutes in an hour). -- Rick (MVP - Excel) "First Aid Computing" <First Aid wrote in message ... Greetings. I have recently been handed a project dealing with process times. I have one set of numbers as seconds (ss.ssssssss) and one as a decimal version of minutes (.91 m). What process do I need to know to convert these numbers into a workable format. I'm hoping to have them as mm:ss.ss and then doing basic math with the results. Thanks in advacne. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculus | Excel Discussion (Misc queries) | |||
| How to do integral calculus in Excel spreadsheet? | Excel Worksheet Functions | |||
| Basic Propositional Calculus - Sources for Beginners | Excel Discussion (Misc queries) | |||
| You should design a way of doing algebra calculus on a computer | Excel Worksheet Functions | |||
| Calculating tvl time in Excel 2000 Rev.9.2720 | Excel Worksheet Functions | |||
Linear Mode
