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 :confused:


--
nikkimc
------------------------------------------------------------------------
nikkimc's Profile: http://www.excelforum.com/member.php...o&userid=30218
View this thread: http://www.excelforum.com/showthread...hreadid=498981

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

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 :confused:


--
nikkimc
------------------------------------------------------------------------
nikkimc's Profile:
http://www.excelforum.com/member.php...o&userid=30218
View this thread: http://www.excelforum.com/showthread...hreadid=498981

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

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

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 -