Subtracting Dates/Times

  • Thread starter Thread starter Ken Belisle
  • Start date Start date
K

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
 
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
 
Back
Top