Time Calculation

[sjl]

How do i format and calculate the time say for example 6/5/06 at 3:30 pm to
6/6/06 4:35 pm?

Thanks, sjl

 

[David Biddulph]

How do i format and calculate the time say for example 6/5/06 at 3:30 pm
to
6/6/06 4:35 pm?

=A2-A1, and format as [h]:mm, or whatever you prefer.