| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 20767 | 2002-06-11 08:33:00 | Time calculation in Excel | Guest (0) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 53847 | 2002-06-11 08:33:00 | I have a need to sum the amount of minutes between 2 times. Eg, start 7.32am - finish 1.33pm. (13:33 in 24 hr time) but I cannot get the answer in minutes. I can format both as time in Hr:mm but only get a result in Hr:mm. Does anyone know how to get the result in minutes only. Excel does not appear to have this format available. Thanks |
Guest (0) | ||
| 53848 | 2002-06-11 08:47:00 | =(D4-D5)*24*60 if d4 and d5 are times, format the answer as a plain number. Answer is as a fraction of 24 hours, the above gets it into minutes. robo. |
Guest (0) | ||
| 53849 | 2002-06-11 10:51:00 | Thanks Robo, I'll try it tomorrow at work. | Guest (0) | ||
| 53850 | 2002-06-11 11:14:00 | To Andy P. Just out of sheer nosy curiosity, why would you want to do that? John M | Guest (0) | ||
| 53851 | 2002-06-12 09:38:00 | Hello John M, The reason I want to do this is because I measure production efficiency for a certain machine. I get a printout from that machine that gives me a start & finish time. I have previously been calculating the time manually & entering it into a speadsheet. Now I do not need to. Just another small time saver! Andy |
Guest (0) | ||
| 1 | |||||