Thread: Add times, convert to number not time of day?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
spezticle spezticle is offline
external usenet poster
  
Posts: 12
Default Add times, convert to number not time of day?
Okay, this should be pretty simple.

17:24:00 + 00:24:00 = 7

5:00 PM + 9:30 PM = 4.5

That's what i'm trying to achieve.
A start time, a finish time, and the time it took between them.
Not a clock time of 5pm + 9pm = 2am

How can this be done?
thanks,

Benjamin
Reply With QuoteReply With Quote