time adjustments

M

Michael Vestel

I have collected time and temperature data. The time data is in time format
(13:30:00 for example) the time data needs to be correlated to another set of
data (images) that are time stamped in seconds (like 3456s). I know that the
time of 1820s on my image correlates with 15:44:00 in the excell spread
sheet. I'd like to convert the 15:44:00 to 1820 sec and all other time in the
column be appropriatly scaled. I tried subtractin 15:44:00 from all the
times, but that only works for postivive differences (times that are after
15:44:00). In addtion, i dont know how to convert to seconds and then add in
the 1820s offset. Can someone suggest somethign?
 
D

David Biddulph

Format as doesn't change the value, so you can't subtract a number in
seconds from that.
To convert 15:44:00 to seconds, multiply by 24*60*60 (converting from
Excel's days to hours, then minutes, & then seconds), & format as General or
Number.
--
David Biddulph

Teethless mama said:
Format as:


Michael Vestel said:
I have collected time and temperature data. The time data is in time
format
(13:30:00 for example) the time data needs to be correlated to another
set of
data (images) that are time stamped in seconds (like 3456s). I know that
the
time of 1820s on my image correlates with 15:44:00 in the excell spread
sheet. I'd like to convert the 15:44:00 to 1820 sec and all other time in
the
column be appropriatly scaled. I tried subtractin 15:44:00 from all the
times, but that only works for postivive differences (times that are
after
15:44:00). In addtion, i dont know how to convert to seconds and then add
in
the 1820s offset. Can someone suggest somethign?
Click to expand...
Click to expand...
 
Top