Forum Discussion
How do you convert from standard time to unix time in Excel?
I guess military time is only the matter of formatting - if you have 01:34 time in Excel, applying hhmm it'll be shown as 0134.
Actually in Excel date is integer sequential number starting from 1 which equal to Jan 01, 1900. Time is decimal part of the number, 12:00 will be 12/24 = 0.5
Thus, if you use time only it is assumed Jan 01, 1900 as the date, e.g. 1900-01-01 01:34 for above time. Above formula compares it with 1970-01-01 00:00 and returns wrong result.
In brief, year is to be adjusted, e.g with TODAY(). I'm not sure what is the "time only" in UNIX. But for absolute time it could be like
SergeiBaklanOnly the time. Military time to be exact.
I guess military time is only the matter of formatting - if you have 01:34 time in Excel, applying hhmm it'll be shown as 0134.
Actually in Excel date is integer sequential number starting from 1 which equal to Jan 01, 1900. Time is decimal part of the number, 12:00 will be 12/24 = 0.5
Thus, if you use time only it is assumed Jan 01, 1900 as the date, e.g. 1900-01-01 01:34 for above time. Above formula compares it with 1970-01-01 00:00 and returns wrong result.
In brief, year is to be adjusted, e.g with TODAY(). I'm not sure what is the "time only" in UNIX. But for absolute time it could be like