If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
time and date problems still
Bob,
I can get it to give me the time but it will come up o' in the date. As shown A1 B1 C1 01/03/05 02:00 PM 01/03/05 02:59 PM 01/00/00 00:59 What I want it to do is show the same date and minutes. Also, if it runs into the next day I want to put time restrictions on it as well. (i.e. the work time ends 7pm and resumes at 8am) |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Calendar Question | Josh | General Discussion | 7 | March 28th, 2005 11:19 PM |
Aggregating Date Data into Weeks and Quarters | Roger | Running & Setting Up Queries | 3 | July 11th, 2004 05:56 PM |
Calculating (Date and Time) differences | Frank Kabel | Worksheet Functions | 2 | April 27th, 2004 11:19 PM |
Calculating (Date and Time) differences | Madcap | Worksheet Functions | 0 | April 27th, 2004 08:56 AM |
Subtracting Time Zone for Universal Time and Date | Pal | Worksheet Functions | 1 | February 2nd, 2004 05:04 AM |