Comments by soothingshruti

soothingshruti 3-Mar-12 2:17am View

Thanks a lot Rajdeep

soothingshruti 2-Mar-12 7:56am View

Thanks for reply Rajdeep,
your sum of hours is gives result only in HH i want also in HH:MM and
i want sum of total hours for a particular start date and end date

soothingshruti 2-Mar-12 2:30am View

i am using sql server

soothingshruti 2-Mar-12 2:28am View

thanks for reply,i think you didn't understand my question.
when user is select particular date then i want totalhours on that date.
there are multiple entries from different time.
i am giving you a exam.-

employeeid startdate enddate totalhours
100 2012-02-20 12:00:00.000 2012-02-20 13:00:00.000 1.0
100 2012-02-20 14:00.000 2012-02-20 18:00:00.000 2.0
100 2012-02-20 10:45:00.000 2012-02-20 12:00:00.000 1.5

user is give the date 20/02/2012 .

soothingshruti 2-Mar-12 2:17am View

user just enter start date and end date with time.
an insert querry Convert.ToDecimal(TotalTimeTaken)

soothingshruti 2-Mar-12 2:11am View

when i am inserting the data ,
i wrote this code-

HourTaken = EnDate.Subtract(StrDate);
Int32 hour = HourTaken.Hours;
Int32 Min = HourTaken.Minutes;
TotalTimeTaken = hour + "." + Min;

Comments by soothingshruti (Top 6 by date)