=today() plus time?

[shaftdx]

Good morning

Is there a way that I can use the =today function so that the date will change everyday but I can have a static time?

Like everyday I have several routes that need to be covered at the same time but the drivers change. I set up an automation software that everytime the date changes the new driver in the rotation will appear on the calendar. but it will only work in 01/09/23 4:30 pm Format

 

[Fluff]

How about

=TODAY()+TIME(16,30,0)

 

[shaftdx]

How about

=TODAY()+TIME(16,30,0)

That did it! thank you! So **** easy if I had actually thought about it...in my head I could not add time if there was no starting time, not thinking the starting time was midnight! as soon as you posted it I thought "Yeah that makes sense...."

 

[Fluff]

Glad to help & thanks for the feedback.