Explanation
TheUnix time stamptracks time as a running count of seconds.
to see the value displayed as a time, atime formatneeds to be applied.
Convert Excel time to Unix time
To convert a time in Excel's format to a Unix time stamp, you can use a formula based on the DATE function. In the example shown, the formula in C5 is: =(B5-DATE(1970,1,1))*86400
