Onplace between two times

Copper Contributor

In one column i have a start time (11:00) and in another an end time (18:00).

Can I make Excel understand that a person is on place at 16:59?

My potential end result is maybe to create a form. Where I want to search for a person on a given place on a given time.

2 Replies

@Anders402659 , yes time in Excel is actually decimal number. You may check as with any other number, for example

=IF( (myTime> = startTime)*(myTime <= endTime), "here", "not here")

 

Thank you that helped. Now I have to hink further....on the next step