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.
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Floored hh:mm from concatenated date & time cells
0
Answers
1
Solution; - =TIME(HOUR(Sheet1!BB3),FLOOR(MINUTE(Sheet1!BB3),1),0)
where Sheet1!BB3 is the date & time string formatted as date value.