Forum Discussion
Excel with time cal error
Hi Paul,
The result of the formula is correct, to prove that:
| 6:34:00 AM | |
| 6:35:00 AM | |
| 6:36:00 AM | |
| 6:37:00 AM | |
| 6:38:00 AM | |
| 6:39:00 AM | |
| 6:40:00 AM | |
| 6:41:00 AM | |
| 6:42:00 AM | |
| 6:43:00 AM | |
| 6:44:00 AM | |
| 6:45:00 AM | |
| 6:46:00 AM | |
| 6:47:00 AM | |
| 6:48:00 AM | |
| 6:49:00 AM | |
| 6:50:00 AM | |
| 6:51:00 AM | |
| 6:52:00 AM | |
| 6:53:00 AM | |
| 6:54:00 AM | |
| 6:55:00 AM | |
| 6:56:00 AM | |
| 6:57:00 AM | |
| 6:58:00 AM | |
| 6:59:00 AM | |
| 7:00:00 AM | |
| 7:01:00 AM | |
| 7:02:00 AM | |
| 7:03:00 AM | |
| 7:04:00 AM | |
| 7:05:00 AM | |
| 7:06:00 AM | |
| 7:07:00 AM | |
| 7:08:00 AM | |
| 7:09:00 AM | |
| 7:10:00 AM | |
| 7:11:00 AM | |
| 7:12:00 AM | |
| 7:13:00 AM | |
| 7:14:00 AM | |
| 7:15:00 AM | |
| 7:16:00 AM | |
| 7:17:00 AM | |
| 7:18:00 AM | |
| 7:19:00 AM | |
| 7:20:00 AM | |
| 7:21:00 AM | |
| 7:22:00 AM | |
| 7:23:00 AM | |
| 7:24:00 AM | |
| 7:25:00 AM | |
| Count | 52 |
Please note that the formula doesn't include the start time in the calculation this is why it gives you 51 while the count result in the table above is 52.
Hope that helps
Sorry but the starting time is 6:34AM and the ending time is 7:25AM, so we have 1 Hour and 9 minutes.
I use this formula to calculate the time of a starting and ending of a radio program.
So if the program started at 6:34AM and ended at 7:25AM the program was 1 hour and 9 minutes long and not the 51 minutes showing in the excel calculation.
Note: The two first calculation are correct but the third one is over one hour and Excel does not give me the correct answer.
Thank you;
Paul
Paul, adding an hour to starting time 0634 gives 0734 which is later than 0725, thus you have less than one hour in that period of time
Hi guys....
Sorry; I must have overdone my work time (kkkkkkkkkkk)
It is absolutely right!
I apologies for this mistake... (better I take a rest)
Thank you Haytham and Sergei
