Convert integer to time query
Thanks Toppers, that's great.
"Toppers" wrote:
try:
=TIME(LEFT(D1,LEN(D1)-2),RIGHT(D1,2),0)
"Bryony" wrote:
Hi, I've exported data from different software which only recognises integers
and now need to convert these values to time e.g. 950 to 09:50 and 1000 to
10:00. I've tried a few formulas with no success, the closest I got was
using left, right and mid functions but this doesn't seem to work for the
complete dataset as the number of characters switches between 3 and 4. I'd
be very grateful for your advice on how to convert integers to time, cheers.
|