Thread: Time formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Auric__ Auric__ is offline
external usenet poster
 
Posts: 538
Default Time formula

Meanie wrote:

Anyone know if there is a function for subtracting the difference
between two times, though, using negative data such as 2:51 am - 9:08
pm. Yes, I could figure it out in my head but when one has to do
hundreds of them, it's time consuming.


See this thread for dealing with midnight (watch the wordwrap):

https://groups.google.com/forum/#!
topic/microsoft.public.excel.worksheet.functions/aDkj8ab8iwY

--
Don't worry, I'm sure your Mom thinks you're cool.