Forum Discussion
Extract Timestamp Information?
Attached is the scan data I have from an audit, I need to find a way to tell me how long each room took me to scan. I have tried averaging column B, which didn't work. I also used the =right(b2, 11) ...
Use flash fill to extract only Time from Time stamp, not only used for separate time, it can be used for extract specific text or numbers from the range.