Abstract floored Time (hh:mm) from concatenated Date & Time yyyy.mm.dd hh:mm:ss

[Bebbspoke]

Hi; - ... should be simple; -

Col A contains Date & Time stamp as "yyyy.mm.dd. hh:mm:ss"

Please, I require Col B to contain floored hh:mm

Should be easy... nowhere can I find a sensible documentation wrt Excel syntax!!!

Cheers & thanks, Bebbspoke

 

[pgc01]

Hi

What do you have in column A

- string value like "yyyy.mm.dd. hh:mm:ss"
or
- date value formatted like "yyyy.mm.dd. hh:mm:ss"

Remark: you can test with =ISTEXT(A1) to check if it's a string value

 

[Bebbspoke]

Hi pgc01 - data is formatted as date value (original source was text). I've achieved a solution: -

=TIME(HOUR(Sheet1!BB3),FLOOR(MINUTE(Sheet1!BB3),1),0)

Maybe others may find the solution helpful.