Forum Discussion

LesPink's avatar
LesPink
Copper Contributor
Mar 30, 2020

how do i subtract date and time into hours and convert hours to decimal in excel

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:...
excel
Formulas and Functions
Macros and VBA
  • LesPink's avatar
    LesPink
    Copper Contributor
    Mar 30, 2020

    SergeiBaklan 

    Thanks Sergei. I tried that and it didnt seem to be working, but you are correct. Appreciate you taking the time to help. Les

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Mar 30, 2020

      LesPink , did you check the file I attached to previous post?

Resources