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) ...
Something to keep in mind when using the RIGHT function on date/time.
In this snip, Column B is showing what Excel sees when you run the RIGHT formula. You might use some TIME functions to pull the HOUR, MINUTE, SECOND.