Say I have this:
Start Time..........End Time.........Total Time
6/26/08 1:00 6/27/08 1:15....0:15 ????
If I try to do a calculation it will just give me 15 minutes even though the total time is actually 24 hours and 15 minutes.
How can I get excel to recognize that an entire day has passed and show me a total time of 24 hours and 15 minutes in column c?
Start Time..........End Time.........Total Time
6/26/08 1:00 6/27/08 1:15....0:15 ????
If I try to do a calculation it will just give me 15 minutes even though the total time is actually 24 hours and 15 minutes.
How can I get excel to recognize that an entire day has passed and show me a total time of 24 hours and 15 minutes in column c?