Forum Home
Press F1
 
Thread ID: 65810 2006-01-31 21:04:00 Calc time diff in Access user (1404) Press F1
Post ID Timestamp Content User
425866 2006-02-01 03:04:00 Better not be, it's a bike event. They've got serious problems if they are! user (1404)
425867 2006-02-01 03:18:00 No worries! :D andrew93 (249)
425868 2006-02-01 04:02:00 You've discovered the true format of dates, both in Access and Excel.

If you enter .5 into an Excel cell, and format it as a time you get 12pm.

So if "1" is 24 hours, and ".5" is 12 hours, then a minute is 1/(24*60) or 0.000694444
kingdragonfly (309)
1 2