Date and Time Problem

  • Thread starter Thread starter JDBARNES63
  • Start date Start date
J

JDBARNES63

I need to have the current day autofill a cell but it needs to be base
on a time change at 0700 hrs. What I need is to be able to fill out m
form, have the current date display in the cell but when the syste
clock changes to 0700 the date will roll up to the next day.


0100 hrs 4/18/06
0600 hrs 4/18/06
0900 hrs 4/19/06
2059 hrs 4/19/06
0100 hrs 4/19/06
0500 hrs 1/19/06
0705 hrs 1/20/0
 
Based on your written description (not your table):

=NOW()+17/24

will move the time forward 17 hours so that 7am today turns over to
tomorrow's date.
 

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

Subtracting time...again 2
Date and Time setup 2
Time Calculation 5
SUMPRODUCT 5
Group Time 3
Conditional + date calculation 1
Calcualting and Adding Time Values in Exc 2003 1
Vacation Date Problem 5

Back
Top