ExcelBeginner34
New Member
 Joined
 Mar 2, 2019
 Messages
 41
 Office Version

 2016
 Platform

 Windows
Hi,
Hoping to get some help. A colleague of mine has sent me the attached file. The have asked if there is an easy was to work out the difference in time between col A and B. From what I can tell, the data is just entered as text as it is left aligned. I assume that I need some way to convert this text to a date and time format then subtract the earlier date/time from the latter to work out the difference. I just can't figure out how to do this!
Any help would be very much appreciated.
Best regards
Iain
Hoping to get some help. A colleague of mine has sent me the attached file. The have asked if there is an easy was to work out the difference in time between col A and B. From what I can tell, the data is just entered as text as it is left aligned. I assume that I need some way to convert this text to a date and time format then subtract the earlier date/time from the latter to work out the difference. I just can't figure out how to do this!
Any help would be very much appreciated.
Best regards
Iain