I have been trying to subtract time and have tried all the suggestion I have reviewed on the message board and external links and still cannot get it to work. The spreadsheet originally had time displayed as 11:20:01 a.m. I used text-to-column and separated the time from a.m. Looking at the spreadsheet everything is working except when the time changes from a.m. to p.m. When I look at the p.m. time field, it shows as a.m. and I am getting a negative number. See row D.
Any help would be appreciated. Thanks!!
This message was edited by bbabine on 2002-07-03 04:02
Any help would be appreciated. Thanks!!
Book1 | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | Date | Login/LogoutTime | Calculation | ||||
2 | 05/09/2002 | 11:20:01 | a.m. | ||||
3 | 05/09/2002 | 11:20:07 | a.m. | 0:00:06 | |||
4 | 05/09/2002 | 1:49:37 | p.m. | -9:30:30 | |||
5 | 05/09/2002 | 1:58:21 | p.m. | 0:08:44 | |||
6 | 05/09/2002 | 3:15:27 | p.m. | 1:17:06 | |||
7 | 05/09/2002 | 3:47:03 | p.m. | 0:31:36 | |||
8 | 05/09/2002 | 4:37:29 | p.m. | 0:50:26 | |||
9 | 05/09/2002 | 4:38:06 | p.m. | 0:00:37 | |||
10 | 05/09/2002 | 4:38:54 | p.m. | 0:00:48 | |||
11 | 05/09/2002 | 4:39:29 | p.m. | 0:00:35 | |||
12 | 05/09/2002 | 4:57:34 | p.m. | 0:18:05 | |||
13 | 05/09/2002 | 5:06:30 | p.m. | 0:08:56 | |||
14 | 05/09/2002 | 6:01:38 | p.m. | 0:55:08 | |||
15 | 05/09/2002 | 6:16:50 | p.m. | 0:15:12 | |||
16 | 05/09/2002 | 6:16:50 | p.m. | 0:00:00 | |||
17 | 05/09/2002 | 6:50:52 | p.m. | 0:34:02 | |||
18 | 05/09/2002 | 6:50:52 | p.m. | 0:00:00 | |||
19 | 05/09/2002 | 7:11:15 | p.m. | 0:20:23 | |||
20 | 05/09/2002 | 7:11:15 | p.m. | 0:00:00 | |||
21 | 05/09/2002 | 7:43:34 | p.m. | 0:32:19 | |||
22 | 05/09/2002 | 7:43:34 | p.m. | 0:00:00 | |||
23 | 05/09/2002 | 8:03:38 | p.m. | 0:20:04 | |||
24 | 05/09/2002 | 8:03:38 | p.m. | ||||
Sheet1 |
This message was edited by bbabine on 2002-07-03 04:02