Mar 30 2020 12:49 AM
I am trying to subtract cells that contain a date and time from another cell that contain a date and time into hours and then convert that to a decimal. E.g. 18/10/2018 4:53:50 AM minus 17/10/2018 5:12:30 PM equals (hours as a decimal number). Anyone any ideas how I can reliably do this? Thanks in advance.
Mar 30 2020 12:54 AM
Mar 30 2020 01:05 AM
Thanks Sergei. I tried that and it didnt seem to be working, but you are correct. Appreciate you taking the time to help. Les
Mar 30 2020 01:12 AM
@LesPink , did you check the file I attached to previous post?