adding the total hours worked in 5 weeks

  • Thread starter Thread starter Tisheina
  • Start date Start date
T

Tisheina

I'm making a time sheet to keep track of the time I've worked and most of it
is finished but I cant get the total hours, the program counts the hours as a
day if it reaches over 24 hours. The total hours should be 82 hrs (10mins)
but it shows as 1/4/1900 5:06....
 
Right click the total cell. Format Cells>Custom Type

[h]:mm


If this post helps click Yes
 
Hi,

change the format of the time cells to
[h]:mm:ss
You can do this by choosing Format, Cells, Number tab, Custom and entering
the above on the Type line or hunting it down in the list while Custom is
selected.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Completing Formula For Hours Worked 3
Calculate OT/TIL hours when 1st 2 hrs are double time, rest are 1: 2
help cumulative hrs 1
formula or calculation for adding negative hour and positive hours 1
time sheet needed to total weekly hours worked by staff 1
Hours over 24 6
Timesheet hours format not adding 2
Calculate Total hours worked during workdays within given shift time. 2

Back
Top