sum hours

  • Thread starter Thread starter mcnews
  • Start date Start date
M

mcnews

i have a punch in, punch out, and hours columns. the first two fields
are date time. i use a time function the subtract pinch in from punch
out to get hours.
i want to sum those hours on my timesheet.

e.g.

=sum(hours)

3.57
1.59
4.54

is there a time function that would sum these correctly?

tia,
mcnewsxp
 
i have a punch in, punch out, and hours columns.  the first two fields
are date time.  i use a time function the subtract pinch in from punch
out to get hours.
i want to sum those hours on my timesheet.

e.g.

=sum(hours)

3.57
1.59
4.54

is there a time function that would sum these correctly?

tia,
mcnewsxp
Click to expand...

this seems to work:
=Format(Sum([hours]/24),"h:nn")
 
Back
Top