Member Avatar for sbchandru

Dear sir,
I doing one school project in VB6 with Access database. here I use Data bound grid control for view. and I want know how to calculate hours in DBcrid pls help me.

  • 1 Contributor
  • 1 Reply
  • 59 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by sbchandru
Member Avatar for sbchandru

Hi,

Instead of simply using Sum, use this Query:

Select Sum(Val(MyDateTimeFld)) From MyTable

You will get total Time,
Later you need to get the Decimal Part, Integer Divide by 60, add it to Hours part, and keep the remainder in Decimal for Minutes..

Regards
Veena

Thank I apply this code now

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.