Using Excel 2007, how do I calculate the time difference by entering
- a start time
- an end time
What format do I use in the cells where the time is?
For example, I'd like to be able to enter
0800 and see
0800 in the box, or enter
1430 and see
1430 in the box. Then I'd like to have the formula box display the time lapsed in hours and minutes.
A1 = 0800
A2 = 1430
A3 (A1-A2) = 6.30*