Hour counter

  • Thread starter Thread starter Earl
  • Start date Start date
E

Earl

I am trying to create a cell that will give me a numeric
value that starts at 24 and reduces by one for every hour
that passes. I am having difficulty doing this with excel.
My start time would be at 12:00:00 of one day and stop at
12:00:00 the next day. If you have any suggestions I could
sure use them.

Thank you
 
Earl

I'm not certain if this is what you want as I'm not certain if you want to
run from noon to noon or midnight to midnight.
If you want to run from noon to noon.

=IF(HOUR(NOW())<12,12-HOUR(NOW()),36-HOUR(NOW()))

should do it for you.
If you want to run from midnight to midnight

=IF(HOUR(NOW())=24,24,24-HOUR(NOW()))

is the answer.

HTH
Henry
 
Back
Top