View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default Q: Time Difference

hi,
that is a simple subtraction.
if start time is in A1 and end time is in B1, formula in C1 would be....
=b1-a1

I'm using xp. worked for me.
Regards
FSt1

"JIM.H." wrote:

Hello,
I need to find the difference between two time value as hours. I have two
cells that keeps the time, so between 8:00am and 9:30am, it means 1.5 hours.
Is this possible?