Now rounded to the hour

[dmheller]

All,
I must be doing something way wrong. I am trying to have something in excel that is
=Now(Hour(1)) so I am wanting to round down to the nearest hour. I am sure this is beyond simple but I can not get it. any help would be great.
thanks

 

[steve the fish]

Try:

=FLOOR(A1,1/24)

 

[steve the fish]

Well:

=FLOOR(NOW(),1/24)

 

[dmheller]

that's what I did, the second one it worked thanks

 

[dmheller]

One last one, to then take that date and subtract 1 day and all the hours so it starts on 00:00 what would I do there? so if
=FLOOR(now(),1/24) returned 9/7/17 08:00 and I wanted the next to say 9/6/17 00:00

 

[steve the fish]

Then you can use:

=TODAY()-1

 

[dmheller]

Well I made that way to hard. =DATE(YEAR(B2),MONTH(B2),DAY(B2))-1