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. Wher...
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