Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
time box
I want to make a box which is in military time tied back to a range of cells.
Can it be done and how could it be easily done. Thanks for help -- ED |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
time box
Four steps:
1. insert this User Defined Function: Function gmt() As Date Application.Volatile dot = "." Set Serve = GetObject("winmgmts:\\" & dot & "\root\cimv2") Set Zones = Serve.ExecQuery("Select * From Win32_TimeZone") For Each Zone In Zones intTimeZoneBias = Zone.Bias intDayLightBias = Zone.DaylightBias Next gmt = Now() - (intTimeZoneBias - intDayLightBias) / (60 * 24) End Function 2. in cell A1, enter: =gmt() 3. put a rectangle on your worksheet using the Drawing toolbar 4. click on the rectangle to select it and then click in the formula bar and enter: =A1 -- Gary''s Student - gsnu200796 "Ed" wrote: I want to make a box which is in military time tied back to a range of cells. Can it be done and how could it be easily done. Thanks for help -- ED |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
time box
Right-click on the cell you want to be your 'box'.
Select 'Format Cells...' from the menu. Select 'Time' Select the military time format you want. -- Hope this helps. Thanks in advance for your feedback. Gary Brown "Ed" wrote: I want to make a box which is in military time tied back to a range of cells. Can it be done and how could it be easily done. Thanks for help -- ED |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time calculations for Scheduled Time vs. Actual Time Worked | Excel Discussion (Misc queries) | |||
straight time, time and a half, and double time | Excel Discussion (Misc queries) | |||
Calculate Ending time using Start Time and Elapsed Time | Excel Worksheet Functions | |||
Comparing 2 files on date/time stamp, and based time difference do a subroutine | Excel Programming | |||
Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions |