problem sum between column

[squidy]

i face a problem when i doing sum between column


for example:
column A : 2012-02-02 17:00:00.000 (DateTime)

column B : 45 (decimal) <--- minutes

i had try many time to add them. but it fail..
the answer i want is 17:45..

anyone can help me???

[HighAley]

Hello.

i face a problem when i doing sum between column


for example:
column A : 2012-02-02 17:00:00.000 (DateTime)

column B : 45 (decimal) <--- minutes

i had try many time to add them. but it fail..
the answer i want is 17:45..

anyone can help me???

You should use code like next:

Code: Select all

{yourDateTimeField.AddMinutes(yourMinutesFieldTypeDouble)}

Thank you.

[squidy]

Hello.

i face a problem when i doing sum between column


for example:
column A : 2012-02-02 17:00:00.000 (DateTime)

column B : 45 (decimal) <--- minutes

i had try many time to add them. but it fail..
the answer i want is 17:45..

anyone can help me???

You should use code like next:

Code: Select all

{yourDateTimeField.AddMinutes(yourMinutesFieldTypeDouble)}

Thank you.

oh~~ thank you very much~~ i solve it!!

[Andrew]

Great!

Have a nice day!
Thank you.