Cell with current time without the date

[LambChoptheKid]

I am trying to create an IF statement that reads "Valid" if the current time is between the hours of 10AM and 3PM.

To do this my idea was to have an isolated cell which contains a formula which displays exclusively the current time that can then be referenced in said IF statement.

However, I cannot find a way to get the current time without referencing a date to go with it. I have tried to use the NOW function but that includes the date which I do not want.

Is it possible to do this in excel? I thought it would be easy but I'm having trouble finding any resources to point me in the right direction.

Thank you

 

[Beneindias]

=Time(Hour(Now());minute(now());second(now)))

 

[Fluff]

How about

=MOD(NOW(),1)

 

[LambChoptheKid]

=Time(Hour(Now());minute(now());second(now)))

This worked. Thank you!

 

[Fluff]

Did you try the simpler formula I suggested?

 

[LambChoptheKid]

Did you try the simpler formula I suggested?

I did, unfortunately it displayed a date of 1/0/1900. Thank you though!

 

[Fluff]

You need to format the cell as time.

 

[LambChoptheKid]

I did, unfortunately it displayed a date of 1/0/1900. Thank you though!

Looking at it some more it appears to give the same result, in that case I will use the simpler formula.

Thank you for the help

 

[LambChoptheKid]

You need to format the cell as time.

lol yup I just tried that. Thanks for pointing that out!

 

[Fluff]

Glad we could help & thanks for the feedback.