HelpExcel.xlsx
Attached is an example of what I'd like to learn how to do. I need to know how to calculate running totals with the first timestamp being the starting time. The only number i need is a running total of time elapsed in hours. 6 decimal places is fine. Hope you can help! Feel free to ask any more questions.
Thanks,
awilson
Last edited by AWilson012; 07-11-2012 at 03:18 PM.
=C3 * 24 format cell as number with 6 decimals
Is that what you are looking for?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
In Cell C2 use =SUM($B$2:B2) and drag down
Column 'D' should be ColumnC*24 formatted as number with 6 decimals.
Life's a spreadsheet, Excel!
Say thanks, Click *
Thanks guys for the solution and immediate response. You guys are the best.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks