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*`