LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
jenniss
 
Posts: n/a
Default How can i tell excel to cumalative the hours so 17:00 + 10:00 = 2.

I have designed a timesheet in excel thats works out staff hours.

I want excel to have a cumalative hours section so on a day to day basis
staff know how many hours they have done it total

I have done a formula to add up the hours but the problem is once it reached
23:59 it goes back to 0:00

does anyone know how to do cumaltive hours and resolve the problem???


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
How do I isolate my Excel server (automation) from other Excel instances? Joseph Geretz Excel Discussion (Misc queries) 5 July 19th 13 03:18 PM
excel template that can add up hours and cost per hour Slikdave Excel Discussion (Misc queries) 1 January 5th 05 11:04 PM
VB Automation is Whacking out my Excel Environment Joseph Geretz Excel Discussion (Misc queries) 2 December 29th 04 03:49 PM
Why does excel not see more than 1000 lines in filter mode? Abdullah Kajee Excel Discussion (Misc queries) 7 December 13th 04 01:03 PM


All times are GMT +1. The time now is 08:43 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"