Enter times as follows: If it's 2:05 in the afternoon enter as 2:05 PM or 14:05.
The attached should handle times across midnight, but check....
I took the 12 out and if you key in 0:30 it row 12 it still subtracts from row 16 which is what it is supposed to do. I've tried every format I could...
dcope7 Yesterday, 07:05 PMIt does not! it adds the value 12 and doesn't even look at row 12! In this context it adds 12 days (=288 hours). Barmy.
Until you get formulae right...
Ok row 16 calculates rows 11 and 15, plus it subtracts row 12 and yes I know I have it adding but if you actually add 0:30 in row 12 it will subtract...
dcope7 Yesterday, 05:23 PM
Best method to create training log?
Follow up to Ali's suggestion. Here is a link that I often refer Access Template Lookers to examine. While it does not give you an actual DB, it does...
alansidman Today, 05:54 AM