Date & Time Picker Help

%3CLINGO-SUB%20id%3D%22lingo-sub-1497701%22%20slang%3D%22en-US%22%3EDate%20%26amp%3B%20Time%20Picker%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1497701%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all!%20I'm%20looking%20for%20a%20little%20bit%20of%20help%20regarding%20Date%20%26amp%3B%20Time%20picker.%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20comfortable%20inserting%20a%20date%20picker%20and%20also%20how%20to%20do%20it%20as%20a%20time%20as%20well.%20What%20I'm%20looking%20to%20do%20is%20this%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EColumn%201%3A%20Date%26nbsp%3B%3C%2FP%3E%3CP%3EColumn%202%3A%20Time%20(with%20time%20zone%20selector%20IF%20possible)%3C%2FP%3E%3CP%3EColumn%203%3A%20Australian%20time%20zone%20equivalent%20to%20column%202%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20do%20I%20do%20this%3F%20I%20know%20how%20to%20date%20picker%20on%20multiple%20cells%2C%20so%20that%20is%20all%20good.%20But%20I%20want%20to%20separate%20the%20date%20and%20time%20in%20separate%20columns.%20The%20ultimate%20goal%20is%20to%20have%20a%20time%20picker%20with%20a%20time%20zone%20and%20then%20another%20column%20which%20will%20automatically%20add%20hours%20to%20automatically%20generate%20the%20corresponding%20Australian%20time%20zone.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20find%20when%20I%20go%20to%20put%20a%20second%20time%20picker%20in%20(for%20the%20time)%20I%20can't%20get%20the%20coding%20right.%20Anyone%20can%20help%20on%20this%3F%20I%20have%20the%20correct%20coding%20for%20the%20date%2C%20but%20the%20time%20just%20doesn't%20work.%20Hope%20i'm%20making%20sense.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlso%2C%20is%20it%20possible%20to%20select%20a%20cell%20with%20a%20time%20plus%20a%20time%20zone%20in%20a%20drop%20down%20box%20of%20some%20sort%3F%20Open%20to%20other%20suggestions%20on%20what%20would%20be%20the%20easiest%20way%20to%20do%20this.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1497701%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1497898%22%20slang%3D%22en-US%22%3ERE%3A%20Date%20%26amp%3Bamp%3B%20Time%20Picker%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1497898%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F713991%22%20target%3D%22_blank%22%20rel%3D%22noopener%22%3E%40stephanieporter%3C%2FA%3E%3C%2FP%3E%0A%3CP%3EAlthough%20it%20might%20not%20be%20exactly%20what%20you%20are%20looking%20for%2C%20but%20it's%20good%20to%20know%20about%20some%20options%20available%20as%20add-inns%20in%20the%20Microsoft%20Store.%3C%2FP%3E%0A%3CP%3EI%20frequently%20use%20in%20my%20projects%20the%20%22Mini%20Calendar%20and%20Date%20Picker%22%20to%20add%20any%20date%20to%20a%20cell%20with%20a%20click.%20I%20also%20see%20in%20the%20Microsoft%20Store%20a%20%22Date%20and%20Time%22%20add%20in%20but%20I%20did%20not%20use%20it%20before.%20You%20may%20try%20it.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETo%20access%20FREE%20add-ins%20from%20the%20Microsoft%20Store%2C%20go%20to%20the%20insert%20Tab%20%26gt%3B%26gt%3B%20Get%20Add-ins%20%26gt%3B%26gt%3B%20Office%20Add-ins%20%26gt%3B%26gt%3B%20Search%20%26gt%3B%26gt%3B%20Select%20what%20you%20want%20%26gt%3B%26gt%3B%20click%20Add.%3C%2FP%3E%0A%3CP%3ENote%20some%20Add-ins%20are%20not%20free.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22nabilmourad_0-1593505792490.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F202121iD1A66F7D3CB3DA05%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22nabilmourad_0-1593505792490.png%22%20alt%3D%22nabilmourad_0-1593505792490.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHope%20that%20helps%3C%2FP%3E%0A%3CP%3ENabil%20Mourad%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1500405%22%20slang%3D%22en-US%22%3ERE%3A%20Date%20%26amp%3Bamp%3B%20Time%20Picker%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1500405%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F365248%22%20target%3D%22_blank%22%3E%40nabilmourad%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20so%20much%20for%20your%20reply%2C%20however%20I'm%20doing%20this%20on%20my%20work%20computer%20and%20my%20organisation%20has%20configured%20our%20systems%20to%20block%20ad%20ins.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDo%20you%20have%20any%20other%20suggestions%3F%20Is%20there%20a%20formula%20I%20can%20use%20to%20achieve%20this%3F%20Or%20how%20I%20can%20use%20the%20macros%20to%20have%202%20instances%20of%20Date%20and%20Time%20picker%20in%20the%20same%20spreadsheet%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1500631%22%20slang%3D%22en-US%22%3ERe%3A%20Date%20%26amp%3B%20Time%20Picker%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1500631%22%20slang%3D%22en-US%22%3E%3CP%3EWondering%20if%20anyone%20can%20still%20help%20with%20the%20date%20and%20time%20picker%3F%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20a%20date%20in%20one%20column%20and%20a%20second%20%22time%20only%22%20picker%20in%20a%20second%20column.%20But%20the%20coding%20doesn't%20seem%20to%20work.%20Any%20help%20on%20this%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Hi all! I'm looking for a little bit of help regarding Date & Time picker. 

I'm comfortable inserting a date picker and also how to do it as a time as well. What I'm looking to do is this: 

 

Column 1: Date 

Column 2: Time (with time zone selector IF possible)

Column 3: Australian time zone equivalent to column 2

 

How do I do this? I know how to date picker on multiple cells, so that is all good. But I want to separate the date and time in separate columns. The ultimate goal is to have a time picker with a time zone and then another column which will automatically add hours to automatically generate the corresponding Australian time zone. 

 

I find when I go to put a second time picker in (for the time) I can't get the coding right. Anyone can help on this? I have the correct coding for the date, but the time just doesn't work. Hope i'm making sense. 

 

Also, is it possible to select a cell with a time plus a time zone in a drop down box of some sort? Open to other suggestions on what would be the easiest way to do this. 

 

Thanks

3 Replies
Highlighted

Hi @stephanieporter

Although it might not be exactly what you are looking for, but it's good to know about some options available as add-inns in the Microsoft Store.

I frequently use in my projects the "Mini Calendar and Date Picker" to add any date to a cell with a click. I also see in the Microsoft Store a "Date and Time" add in but I did not use it before. You may try it.

 

To access FREE add-ins from the Microsoft Store, go to the insert Tab >> Get Add-ins >> Office Add-ins >> Search >> Select what you want >> click Add.

Note some Add-ins are not free.

nabilmourad_0-1593505792490.png

 

Hope that helps

Nabil Mourad

Highlighted

Hi, @nabilmourad 

 

Thanks so much for your reply, however I'm doing this on my work computer and my organisation has configured our systems to block ad ins. 

 

Do you have any other suggestions? Is there a formula I can use to achieve this? Or how I can use the macros to have 2 instances of Date and Time picker in the same spreadsheet? 

 

Thanks

Highlighted

Wondering if anyone can still help with the date and time picker? 

I want a date in one column and a second "time only" picker in a second column. But the coding doesn't seem to work. Any help on this?