Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Please Help!! DD:HH:SS to seconds driving me mad
hope someone can help here. Basically have 2 columns - 1 has dd:hh:ss and the second is Seconds - calculates networking data etc...we have a formula which converts the 00:00:00 into seconds but you need to manually type in the dd:hh:ss figure to get this.... Is there a macro which can be used or a formula which says - ok look at A1 which is dd:hh:ss and then convert to seconds and input B1 field...surely there is? is there a script which can be used? please help its driving us mad....thanks in advance people -- nikkimc ------------------------------------------------------------------------ nikkimc's Profile: http://www.excelforum.com/member.php...o&userid=30218 View this thread: http://www.excelforum.com/showthread...hreadid=498981 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Please Help!! DD:HH:SS to seconds driving me mad
can u be more specific and just explain the results u want and is there
any further use with the results? (ie just to show results or take results to another computation ) or some thing like that? yours sajay |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Please Help!! DD:HH:SS to seconds driving me mad
=A1*24*60*60
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "nikkimc" wrote in message ... hope someone can help here. Basically have 2 columns - 1 has dd:hh:ss and the second is Seconds - calculates networking data etc...we have a formula which converts the 00:00:00 into seconds but you need to manually type in the dd:hh:ss figure to get this.... Is there a macro which can be used or a formula which says - ok look at A1 which is dd:hh:ss and then convert to seconds and input B1 field...surely there is? is there a script which can be used? please help its driving us mad....thanks in advance people -- nikkimc ------------------------------------------------------------------------ nikkimc's Profile: http://www.excelforum.com/member.php...o&userid=30218 View this thread: http://www.excelforum.com/showthread...hreadid=498981 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Please Help!! DD:HH:SS to seconds driving me mad
thanks for getting back to me i thought all hope was lost there. Ok i have 3 columns A1 B1 and C1 A1 = dd:mm:ss for e.g. 00:01:20 B1 = mm for e.g 1.2 C1 = ss for example 80 I have a script from another program which fills in A1 with network downtime in a specified month {as above for e.g. 1min and 20s) however i am forced to enter B1 and C1 manually as it does not convert automatically which is what i am looking for. I need to enter 00:01:20 into B1 and it will show me 1.2 - I need to enter 00:01:20 and it will show me 80. Does this make sense? I want a macro or formula that basically says = A1 [B1 - Convert to mm] & [C1 convert to Sec] Hope i have explained this ok. Just want to make a process a little more painless...Thanks again ;) -- nikkimc ------------------------------------------------------------------------ nikkimc's Profile: http://www.excelforum.com/member.php...o&userid=30218 View this thread: http://www.excelforum.com/showthread...hreadid=498981 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Please Help!! DD:HH:SS to seconds driving me mad
Now I'm confused. We went from 2 columns to 3 columns and from DD:HH:SS to
dd:mm:ss. Also in B1 you want a result of 1.2 from a time of 00:01:20 in minutes, but that is 1.333...Minutes. Could you please clarify further? Mike F "nikkimc" wrote in message ... thanks for getting back to me i thought all hope was lost there. Ok i have 3 columns A1 B1 and C1 A1 = dd:mm:ss for e.g. 00:01:20 B1 = mm for e.g 1.2 C1 = ss for example 80 I have a script from another program which fills in A1 with network downtime in a specified month {as above for e.g. 1min and 20s) however i am forced to enter B1 and C1 manually as it does not convert automatically which is what i am looking for. I need to enter 00:01:20 into B1 and it will show me 1.2 - I need to enter 00:01:20 and it will show me 80. Does this make sense? I want a macro or formula that basically says = A1 [B1 - Convert to mm] & [C1 convert to Sec] Hope i have explained this ok. Just want to make a process a little more painless...Thanks again ;) -- nikkimc ------------------------------------------------------------------------ nikkimc's Profile: http://www.excelforum.com/member.php...o&userid=30218 View this thread: http://www.excelforum.com/showthread...hreadid=498981 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Please Help!! DD:HH:SS to seconds driving me mad
yes mike!! we really need the real out put details and input figures
to make a solution nik it seems so simple , go for bob's suggesion type in A1 put the formula in B1 : =A1 put the formula in C1 : =A1*24*60*60 (i didn't worked out the result of 24*60*60 it is above my mind now you may be getting better figures the intention is the get the minutes of a1 figures and show it in :ss:) I guess you have already formated the cells with FORMATE- CELLS- CATEGORY - CUSTOM - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change a minutes and seconds as a 2400 time to seconds? | Excel Worksheet Functions | |||
Entering Seconds but displaying minutes & seconds | Excel Discussion (Misc queries) | |||
Formula to Change Hours:Minutes:Seconds to Seconds only | Excel Discussion (Misc queries) | |||
Converting Julian Seconds with a macro to replace old seconds data | Excel Discussion (Misc queries) | |||
Convert "Time Interval" in "hours : minutes : seconds" to seconds | New Users to Excel |