Page 1 of 1
problem sum between column
Posted: Fri Feb 03, 2012 5:24 am
by 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???
problem sum between column
Posted: Mon Feb 06, 2012 2:36 am
by HighAley
Hello.
squidy wrote: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.
problem sum between column
Posted: Wed Feb 08, 2012 12:47 am
by squidy
Aleksey wrote:Hello.
squidy wrote: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!!
problem sum between column
Posted: Wed Feb 08, 2012 1:23 am
by Andrew
Great!
Have a nice day!
Thank you.