Need help with formula's in a tracking database

B

BobHat

Using Excel XP

I am trying to create a tracking database and need help with the
following:

I know how to insert the current date and time. I will have a start
date/time and a resolved date/time. How do I calculate time
difference between them? (ie length of time to resolve) Would like
Hours & Minutes.

On that calculated field how would I identify those that exceeded 24
hrs? Either a different background cell or different color value of
this field.

Thank You
 
F

Frank Kabel

Hi
simply subtract both values. For identifying > 24 hours use 'Format -
Conditional format). Note: 24 hours are represented by the numeric
value '1'
 
J

JE McGimpsey

XL stores dates and times as integral and fractional days, so you can
simply use math functions:

A1: 29 AUG 2004 12:00
A2: 30 AUG 2004 10:02
A3: =A2-A1 ===> 22:02

Format A3 with Format/Cells/Number/Custom [hh]:mm

to identify > 24 hours (which XL stores as 1), use Conditional Formatting

CF1: =A3>1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy previous record into form field 0
Need formula for calculating time 2
How to work out working hours? 1
Calculate elapsed time excluding specific timeframe 10
Help with a formula for a Time Sheet. 1
date/time formula 1
How to Time time Diff for Completion of Activity (Exc Holiday List & Non Bus Hours) 2
How to calculate difference between two date & time along with working hours and days 2

Top