Time formula
 

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.

Thank you

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.