Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-29-2022, 05:07 PM
bootest bootest is offline auto filling times based on current times Mac OS X auto filling times based on current times Office 2021
Novice
auto filling times based on current times
 
Join Date: Jun 2022
Posts: 1
bootest is on a distinguished road
Default auto filling times based on current times

Hi! I have a report template that I use regularly to create a show report for a theatre I work at. I have subheading and auto resizing text fields for input etc, and an auto updating date field. which is all great, but I would love to have an auto updating time field that updates between two specific times in relation to the time the report is being written.

For example if the report is being written after the 200 pm show, at 5 pm say, the time field would update and show 2 pm. but if it was being written at 11 pm for the 730 pm show, it would update to show 730 pm. Is there a way to do this without using a combobox or implicitly changing the times myself? Thanks in Advance!
Reply With Quote
  #2  
Old 06-29-2022, 05:30 PM
Charles Kenyon Charles Kenyon is offline auto filling times based on current times Windows 11 auto filling times based on current times Office 2021
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,081
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

This would likely better be handled with a Macro.
However, it can be done with fields.
I would suggest that you prepare a template, rather than updating some document. Then use a CREATEDATE field as the basis. That will update each time you create a new document based on the template. You can get times from any of the date fields using a hh:mm picture switch.

You would be using an IF Field to test the time generated in the CREATEDATE and then give you either 7:00 p.m. or 11 p.m. as a result.
Again, a macro would probably be simpler.

Even simpler would likely be two templates. Pick the one you want to use.


I know you said you are using a template. The word "template" means something different in Word than it does in general English.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
auto filling times based on current times Auto filling a calendar based on dates inputted custhasno Excel 4 07-30-2019 04:17 AM
auto filling times based on current times Who Does What, When Report Times cossie2k Project 1 06-26-2013 05:49 AM
Using if statement many times! Jamal NUMAN Excel 6 01-19-2012 12:05 PM
auto filling times based on current times Auto insert current month's name and current year Styler001 Word 4 01-25-2010 06:40 PM
auto filling times based on current times Can I do calculations with times? cubsfan_1 Excel 1 01-14-2010 06:55 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:49 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft