Thread
:
Calculating total work week hours
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
Posts: n/a
Calculating total work week hours
Number will in fact go beyond 24 but the display will not if you use default
time format, use custom format and instead of hh:mm use [hh]:mm
--
Regards,
Peo Sjoblom
"Harley mom" <Harley
wrote in message
...
I have done a time sheet in excell. the columns are Employee name, Time
in,
Time out, Total Hours,- 30 Minute lunch,total hours worked for the day. I
am
now trying to total the number of hours worked for this employee for the
week. I did auto sum but the number will not go past 24. How can i get
this
total for the week
Thanks
Louise
Reply With Quote