Please Help!! DD:HH:SS to seconds driving me mad

[nikkimc]

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

[sajay]

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

[nikkimc]

thanks for getting back to me i thought all hope was lost there.
Ok i have 3 columns A1 B1 and C1

A1 = dd:hh:mm for e.g. 00:01:20
B1 = hh for e.g 1.2
C1 = mm 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. 1hr and 20min) 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 hh] & [C1 convert to mm]

Hope i have explained this ok. Just want to make a process a little more painless...Thanks again

[Bob Phillips]

=A1*24*60*60

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"nikkimc" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Mike Fogleman]

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[sajay]

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