time adjustments
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? |
time adjustments
Format as:
[s] "Michael Vestel" wrote: 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? |
time adjustments
Format as [s] 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" wrote in message ... Format as: [s] "Michael Vestel" wrote: 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? |
All times are GMT +1. The time now is 02:31 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com