Time Convert

  • Thread starter Thread starter 818jaime
  • Start date Start date
8

818jaime

Hello group,
I need help converting time to a general number example 00:00:07, I
need to convert to just plain 7 another example 00:01:07 would be 67
fyi im exporting from avaya IQ

Thank you Jaime
 
Hi Jaime,

Am Mon, 5 Jul 2010 09:24:32 -0700 (PDT) schrieb 818jaime:
I need help converting time to a general number example 00:00:07, I
need to convert to just plain 7 another example 00:01:07 would be 67
fyi im exporting from avaya IQ
Click to expand...

your time in A1, then in B1:
=A1*86400
and format for B1 "general"


Regards
Claus Busch
 
Hi Jaime,

Am Mon, 5 Jul 2010 09:24:32 -0700 (PDT) schrieb 818jaime:


your time in A1, then in B1:
=A1*86400
and format for B1 "general"

Regards
Claus Busch
Click to expand...

Thank's a million, worked perfectly!
 
Back
Top