Results 1 to 2 of 2

Thread: Need help with Time value manipulation

  1. #1

    Need help with Time value manipulation



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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.

  2. #2
    False alarm. Think I figured this out. Not sure how to delete this thread.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •