Subtracting Dates/Times

[Ken Belisle]

Is it possible to subtract an ending date/time from a
start date/time?

Example:

Opened trouble ticket: 08-23-03 @ 07:30 AM
Closed trouble ticket: 08-24-03 @ 09:00 AM

Time ticket open: 25 hours 30 minutes

If this is possible, what are the formats for entering the
original data, what is the formula to calculate and what
is the format for the answer?

This will save me hours and hours on a report.

Thanks,

Ken

 

[Paul Corrado]

Ken,

Enter date & time as

08/23/03 7:30 AM

Find the difference or elapsed time, just subtract the cells with the
beginning and ending time

=B1-A1

To format the cell with the formula to show elapsed time in Hours use

Format|Cell|Custom and enter:

[hh]:mm to show "25:30"
[hh]"Hours" mm "Minutes" to show "25 Hours 30 Minutes"
d h:mm to show 1 1:30
d "Days" h "Hours" mm "Minutes" to show "1 Day 1 Hour 30 Minutes"

PC