Forum Discussion
Onplace between two times
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
