# Excel with time cal error

Copper Contributor

# Excel with time cal error

Time calculation with error:
I try to calculate how many minutes between certain time...
(7:25AM - 6:34AM)
7:25AM
6:34AM
0:51 (ERROR) Should be 1:09

5 Replies

# Re: 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

# Re: Excel with time cal error

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

# Re: Excel with time cal error

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

# Re: Excel with time cal error

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

# Re: Excel with time cal error

No problem. Weekend is not finished, you have some time to refresh the battery.