Home

Onplace between two times

%3CLINGO-SUB%20id%3D%22lingo-sub-482644%22%20slang%3D%22en-US%22%3EOnplace%20between%20two%20times%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-482644%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20one%20column%20i%20have%20a%20start%20time%20(11%3A00)%20and%20in%20another%20an%20end%20time%20(18%3A00).%3C%2FP%3E%3CP%3ECan%20I%20make%20Excel%20understand%20that%20a%20person%20is%20on%20place%20at%2016%3A59%3F%3C%2FP%3E%3CP%3EMy%20potential%20end%20result%20is%20maybe%20to%20create%20a%26nbsp%3Bform.%20Where%20I%20want%20to%20search%20for%20a%20person%20on%20a%20given%20place%20on%20a%20given%20time.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-482644%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-482691%22%20slang%3D%22en-US%22%3ERe%3A%20Onplace%20between%20two%20times%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-482691%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20that%20helped.%20Now%20I%20have%20to%20hink%20further....on%20the%20next%20step%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-482649%22%20slang%3D%22en-US%22%3ERe%3A%20Onplace%20between%20two%20times%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-482649%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F327288%22%20target%3D%22_blank%22%3E%40Anders402659%3C%2FA%3E%26nbsp%3B%2C%20yes%20time%20in%20Excel%20is%20actually%20decimal%20number.%20You%20may%20check%20as%20with%20any%20other%20number%2C%20for%20example%3C%2FP%3E%0A%3CPRE%3E%3DIF(%20(myTime%26gt%3B%20%3D%20startTime)*(myTime%20%26lt%3B%3D%20endTime)%2C%20%22here%22%2C%20%22not%20here%22)%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Anders402659
New 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

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies