Hi - should by a simple problem solve...
but nowhere can I find a decent explantion for the syntax; -
Col A contains data & is formatted "yyyy.mm.dd hh:mm:ss"
(e.g. 2018.04.23 18:29:32)
Col B to contain hh:mm as floored to minute value (i.e. 18:29)
The actual Excel numeric must be floored to enable further processing to the minute timestamp.
Thank you.