how to sum time in ms access

[jvijay]

hi all
i have created a table runtime and entered values as
10:20
5:20
15:30
sum of this time is 30:10
how to write a query so that i can get 30:10 as my answer
thanks
vijay

[missinglinq]

First off, assuming this is supposed to be either minutes and seconds or hours and minutes,

10:20 + 5:20 + 15:30

is going to be

31:10

not

30:10.

I assume this is being stored in a text field, is this correct?

Where are these "times" coming from?

Welcome to Bytes!

Linq ;0)>

[jvijay]

I have create a table in which i created a field as runtime date/time data type and in general formart i selected shorttime then saved the table then i entered the values as 10:20 , 5:20 , 15:30 as hours :minitues .i want to sum this runtime get the answer as 31:10 (hours:mintues) .how to get the result as 31:10
thanks.

[Stewart Ross]

jvijay please do not double-post your questions, which is against site rules and wastes the time of the volunteer contributors to this forum. I have deleted the other thread, a duplicate of post 3 in a separate post.

Linq has asked you for clarification of a point, yet in post 3 you have merely repeated the same data except for correction of your total - this is not answering his request. To post a new thread when you have not answered the question asked in this thread is discourteous. Please be advised that we will not allow misuse of the forum in this way.

Please read our posting guidelines, which are there to help you get the best from this forum.

MODERATOR

[jvijay]

jvijay please do not double-post your questions, which is against site rules and wastes the time of the volunteer contributors to this forum. I have deleted the other thread, a duplicate of post 3 in a separate post.

Linq has asked you for clarification of a point, yet in post 3 you have merely repeated the same data except for correction of your total - this is not answering his request. To post a new thread when you have not answered the question asked in this thread is discourteous. Please be advised that we will not allow misuse of the forum in this way.

Please read our posting guidelines, which are there to help you get the best from this forum.

MODERATOR

I am sorry i could not understand how to thread my reply so i post new question
correcting my question
actually my question is
I have create a table in which i created a field as runtime date/time data type and in general formart i selected shorttime then saved the table. I entered the values as 10:20 , 5:20 , 15:30 as hours :minitues .I want to sum this runtime get the answer as 31:10 (hours:mintues) .How to get the result as 31:10(hrs:min) in ms access.
thanks.
jvijay