Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Misc
Adding cells that have a formula with time in them
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="Ron Rosenfeld, post: 2678555"] It's not that hard to do the addition: Start End HrsWrkd 8:00 AM 5:00 PM 8:00 6:00 AM 2:00 PM 7:00 10:00 AM 1:30 PM 2:30 8:00 AM 4:30 PM 7:30 9:00 AM 5:00 PM 7:00 The formula for the HrsWrkd column is: =End-Start-TIME(1,0,0) Then all you have to do is SUM(HrsWrkd) Format the cell as [h]:mm to prevent the rollover at 24 hours. --ron [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Misc
Adding cells that have a formula with time in them
Top
