in excel totaling weekly hours military time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I really need help. I've been ask to create a time sheet that auto
calculates time both daily total and weekly toals. once my sheet goes past
24 hours the totals are not correct. I've tried changing to absoultes, tried
changing from military time to text, nothing works.
Thank you all,
mel
 
Mel,

Just format the totals cell as [hh]:mm, this will overcome the resetting
trait.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 

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

Weekly Time Sheet Summary 2
Weekly Time Sheet Consolidate 1
Adding up total hours worked on employee schedule using various criteria 0
Calculate time with a break and total hours 5
time sheet am / pm 9
Calculating total work week hours 2
Time Sheet Summary 1
change regular 24 hour format to military time in excel 12

Back
Top