Thread: Time formulas
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tom S Tom S is offline
external usenet poster
 
Posts: 2
Default Time formulas

How do I make a formula for a time that starts at night, (23:30) and ends the
following day (09:00) and come out to be 12.5???? I can make it work for
times on the same day like (09:00 and ends at 23:00) and it shows up as 12.5.
I don't want to have to use a date along with the tme. I sure hope there is
a way to make it work.