Excel with time cal error

[Paul Rech]

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

[#2]

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

[#3]

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

[#4]

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

[#5]

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

[#6]

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