sum hours

[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

 

[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

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