T
tryn''''2learn
Hello,
I'm trying to get total hours when it exceeds 24hrs (working in queries)
in excel it is working fine but when i pull it over to access i'm getting
different data:
excel -
F1 F2 F3 F4 F5 total time
23:19:24 3:59:46 2:39:56 3:59:46 23:19:24 57:18:16
1:14:20 7:07:07 0:24:59 7:07:07 1:14:20 17:07:53
access:
F1 F2 F3 F4 F5 total time
23:19:24 3:59:46 2:39:56 3:59:46 23:19:24 9:18:16
1:14:20 7:07:07 0:24:59 7:07:07 1:14:20 17:07:53
I appreciate your help
I'm trying to get total hours when it exceeds 24hrs (working in queries)
in excel it is working fine but when i pull it over to access i'm getting
different data:
excel -
F1 F2 F3 F4 F5 total time
23:19:24 3:59:46 2:39:56 3:59:46 23:19:24 57:18:16
1:14:20 7:07:07 0:24:59 7:07:07 1:14:20 17:07:53
access:
F1 F2 F3 F4 F5 total time
23:19:24 3:59:46 2:39:56 3:59:46 23:19:24 9:18:16
1:14:20 7:07:07 0:24:59 7:07:07 1:14:20 17:07:53
I appreciate your help