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
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies