MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Subtract times


Posted by Sally on September 25, 2001 3:11 PM

I need to calculate amounts based on the difference between 2 times. If the end time is the morning after the start time is there any way i can subtract the end time from start time? Must I use date and time?

Thanks


Posted by Travis Harr on September 25, 2001 6:26 PM

If you dont want to use date and time, and the difference is never more than 24 hours, then this simple formula will work.
End time + 12 - Start time