Need to calculate time between 2 dates and display Conditional formatting

  • Thread starter Thread starter DoctorV
  • Start date Start date
D

DoctorV

I have some Excel cells with dates formatted like this Thursday, June
2004 8:53 AM. I need the difference in time (Days Hours Minutes
between the 2 cells containing the dates. What would the formula be?

I was trying this

=DATEDIF('Level 2 Support Team Member'!B7,'Level 2 Support Tea
Member'!B35,"md")

but I kept getting a #Value error B35 and b7 are merged with cells t
the right for display, but those are the cells that contain the actua
values.

I wanted to Conditionally format the result so that if the result wa
greater than 1 day or 24 hours that the font would display in red.
Please Help Very important!!! Thanks!!
 
Hi DoctorV!

Just deduct the earliest date/time cell from the latest.

Then apply a custom format such as:

dd "days" hh "hours" mm "minutes"

Now select the cells that contain the differences and use:

Format > Conditional Formatting
Cell Value Is
Greater than
1
Format button
Select Format
OK
OK
 
Back
Top