Excel formula to convert time.

[pedie]

Hi, I Excel formula to convert time to seconds. for example/
<TABLE style="WIDTH: 151pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=200 border=0><COLGROUP><COL style="WIDTH: 53pt; mso-width-source: userset; mso-width-alt: 2560" width=70><COL style="WIDTH: 98pt; mso-width-source: userset; mso-width-alt: 4754" width=130><TBODY><TR style="HEIGHT: 12pt" height=16><TD class=xl63 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 53pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 12pt; BACKGROUND-COLOR: transparent" align=right width=70 height=16>12:05:00 AM</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 98pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right width=130> Expected asnwer= 300</TD></TR></TBODY></TABLE>.

Thanks in advance.

 

[HalfAce]

Hi Pedie!
If your time were in cell A1, how about something like:

=(1*86400)*A1

(Everything going good these days?)

Hope it helps.


EDIT:
I don't know if there's much of a difference, but you could (might want to???) write it this way instead:

=(86400/1)*A1

and in either case, I forgot to mention to format the cell as number instead of time.

 

[pedie]

Hi Dan, perfect! both works great .
and yes everything is going great!!!
i hope everything is going great for you too...are you already in PHP?

 

[HalfAce]

Nope. I'm not in the Philippines yet. (I likely will be a week or so from now though.)