Need help with Time value manipulation

Ejw

New member
Joined
Jun 29, 2014
Messages
2
Reaction score
0
Points
0
Hey guys,

I'm working on a sheet where there is a 'Target date' column and a 'Actual date' column. Where in each cell there is (dd/mm/yyyy hh:mm). What I am trying to do is find when there is more than one hour difference between the target and actual times. I'm not that flash with formulas and frankly have no idea how to do this when there is a date and time in the same cell. I had considered just deleting the date out of the first part of the cell, but then realized how futile this would be with over 5000 data values.

Any help you guys could give would be fantastic.
 

Ejw

New member
Joined
Jun 29, 2014
Messages
2
Reaction score
0
Points
0
False alarm. Think I figured this out. Not sure how to delete this thread.
 
Top