| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 16180 | 2002-02-28 22:36:00 | Excel | Guest (0) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 37474 | 2002-02-28 22:36:00 | I am doing timesheets and want to be able to show say 1.45pm (start) to 2.00pm (end) & caculate the difference which is .15 hrs. I tried to format cell using time but got a funny number. I am using excel 2000. |
Guest (0) | ||
| 37475 | 2002-02-28 22:57:00 | Perhaps you get a strange number because 15 minutes is actually .25 of an hour, not .15? | Guest (0) | ||
| 37476 | 2002-02-28 23:09:00 | Its difficult to fully explain so if i can email you the excel file you can see for yourself. anyone please feel free to contact me directly at mpatel@frl.co.nz |
Guest (0) | ||
| 1 | |||||