| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
1/0/1900 10:18:48 AM Time problem
I try to perform a calculation of the start time and finished time. The start time will be automatic put in by system using now() function and the finish time will be put in by user. The problem is when user enter the time the date is always 1/0/1900 10:18:48 AM, which make the calculation negative. Is there anyway to overcome this problem. -- canix ------------------------------------------------------------------------ canix's Profile: http://www.excelforum.com/member.php...o&userid=25962 View this thread: http://www.excelforum.com/showthread...hreadid=393333 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using VLOOKUP with a Date and Time | Excel Discussion (Misc queries) | |||
| Time Sheets | New Users to Excel | |||
| subtraction of times, convert & multiply by a conditioned rate | Excel Worksheet Functions | |||
| Time Sheet Calculation Help Needed! | Excel Worksheet Functions | |||
| Time Sheets | Excel Discussion (Misc queries) | |||
Threaded Mode
