Highlight a cell if time for task is over one hour

  • Thread starter Thread starter Steve M
  • Start date Start date
S

Steve M

Hi
I would like to be able to highlight a cell to show if a start time in
column a and a finish time in column f was over 1 hour. The highlighted cell
could be the finish time cell or a cell next to it. Any help would be great.
Thankyou

Time format I have in cells is hh:mm

cheers
 
Use conditional formatting with a formula of

=(F2-A2)>=--"01:00"
 
Brilliant worked a treat thanks.

I also wondered if I could do something similar with another sheet where I
could find out if the start time and finish time where over 12 hours. The
cell format for these dd/mm/yy hh:mm. Start time cell C and Finish time cell
L. Some of the times can run into a few days between start and finish so
need it to work with the date too. Hope that makes sense.
 
Apologies, the formla works fine for my second question also.
many thanks
 
You must log in or register to reply here.

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

Calculate the amount of time over a permitted amount (12 hours) 7
if both cells are same highlight 2
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
Subtract 12 hours from date/time 6
How to highlight the lowest valued cell in a column in Excel 2003 2
Subtract times? 2
help Fill formulas, highlight cells to specified destination 1
Conditional formatting for time 1

Back
Top