| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 8578 | 2001-04-05 10:29:00 | Excel | Guest (0) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 10883 | 2001-04-05 10:29:00 | Newbie problem here. Have 2 columns of times hh:mm:ss format. Wish to subtract A1 from B1 to get elapsed time. B1-A1=#VALUE! Seems so simple...? | Guest (0) | ||
| 10884 | 2001-04-05 12:09:00 | Simon, In the menu at the top of the page select 'PC World' then scroll down to 'Everything You wanted to know about Microsoft Excel' and read section 16. It is quite fortuitous that this article is available now, If this is no help - respond to your own post and more info will follow, Cheers |
Guest (0) | ||
| 10885 | 2001-04-06 02:31:00 | Sweet Simply select all cells that will contain time values. Right click on them and choose format cells. Then select time on the left and hh:mm:ss on the right now in A1 enter 15:30:55 in B1 enter 15:45:55 in C1 tpe =B1-A1 the answer will show as 0:15:00 You MUST use : to seperate the values. A full stop (15.30.55) will cause excel to return #value Good luck :) |
Guest (0) | ||
| 1 | |||||