Thread: convert time into decimal
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Richard[_2_] Richard[_2_] is offline
external usenet poster
  
Posts: 34
Default convert time into decimal
=IF(E44="","X",E40-E44)

the formula above where E40 is the time now, and E44 is the time of 2 hours
ago. I want to return 2 instead of 2:00 PM. How do I do this? I do this
but it does not work (E40-E44)*24.


Reply With QuoteReply With Quote