Home |
Search |
Today's Posts |
![]() |
|
uk.sci.weather (UK Weather) (uk.sci.weather) For the discussion of daily weather events, chiefly affecting the UK and adjacent parts of Europe, both past and predicted. The discussion is open to all, but contributions on a practical scientific level are encouraged. |
Reply |
|
LinkBack | Thread Tools | Display Modes |
#1
![]() |
|||
|
|||
![]()
R&D InstroMet Data Logger issue solved....
Upto now I never resolved this issue, but after coming back from a break, downloading the data and once again scratching my head I think I have found the anomaly. Basically it's simple. 1. What is seen on the 'Display' is in 'decimal' 2. Whereas the report off the software is in hours:mins, a simple conversion does the trick Eg, my display reads 5.14, whereas the software reads 5:08. When you think of it the '.' and ':' gives it away. So by putting 5:08 in cell 'B3' with the formula below in cell 'B4' the : =INT(B3)*24+HOUR(B3)+ROUND(MINUTE(B3)/60,2) The result is 5.13. In a few cases it does come out + or - .01 so if you can think of a better formula / conversion method please share :-) Regards Keith (Southend) |
#2
![]() |
|||
|
|||
![]()
On 29/05/2019 19:37, Keith Harris wrote:
R&D InstroMet Data Logger issue solved.... Upto now I never resolved this issue, but after coming back from a break, downloading the data and once again scratching my head I think I have found the anomaly. Basically it's simple. 1. What is seen on the 'Display' is in 'decimal' 2. Whereas the report off the software is in hours:mins, a simple conversion does the trick Eg, my display reads 5.14, whereas the software reads 5:08. When you think of it the '.' and ':' gives it away. So by putting 5:08 in cell 'B3' with the formula below in cell 'B4' the : =INT(B3)*24+HOUR(B3)+ROUND(MINUTE(B3)/60,2) The result is 5.13. In a few cases it does come out + or - .01 so if you can think of a better formula / conversion method please share :-) Regards Keith (Southend) Even the big boys with big toys have such problems. https://www.ntslf.org/data/uk-network-real-time the clock display never reads hours correctly, 8:00 reads 7:60 in their structure, 9:00 reads 8:60 etc. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
InstroMet Sun recorder to Data logger wiring? | uk.sci.weather (UK Weather) | |||
Instromet weather stations - wind direction issue | uk.sci.weather (UK Weather) | |||
The current issue of Weather Magazine (climate change issue) | uk.sci.weather (UK Weather) | |||
Data Logger Query | uk.sci.weather (UK Weather) | |||
WMII Data logger ~ help? | uk.sci.weather (UK Weather) |