#1
|
|||
|
|||
Auto add time up and cost
I have a spreadsheet that has dates, the amount of time spent each day and the cost per hour and minute for each amount of time spent working on a project. Kind of like a timer sheet.
I would like to know if there is a better way to: add the TIME INVOLVED to auto calculate the TOTAL HOURS Take the TOTAL HOURS and calculate them by 5.555 (333.33 an hour = 5.555 a minute) Then the number from MINUTE auto-calculates the COST. Thank you in advance |
#2
|
|||
|
|||
A working table is on 2nd sheet.
I used Defined Table there. When you enter anything into next row immediately below bottom one of Table, all formulas and formats are expanded to new row (so long as you don't have several different formulas or formats in same column!). I added fields with formulas which calculates the total of hours and costs visible in Table (FilteredTotal). When p.e. you set the Autofilter for StartTime of Table to March, the total time and cost for March is displayed in those fields. The column TaskTime and it's total are formatted as "[h]:mm". This format displays hours 24 or more - all other time formats start over at 00:00 whenever the multiple of 24:00 is reached! As follows from your example data, a task can start on one date, and end on next date (or even several days later?). Because this, the start and end times MUST have date included - otherwise there is no way to calculate the time spent on task properly! On your original sheet, I wrote a comment why your formula doesn't work! |
#3
|
|||
|
|||
wow, thank you, love it
I'll play around with it |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Auto update dashboard graph every time a new value is keyed in | dylansmith | Excel | 2 | 11-06-2021 06:47 AM |
Change BaseLine Cost, but not time | AlvaroGN | Project | 3 | 05-09-2021 04:13 AM |
Budget Cost - Baseline Cost | MAJID | Project | 0 | 07-25-2017 05:31 PM |
Cost resource not taken in real cost | pascalbidouille | Project | 1 | 08-21-2015 01:25 PM |
Using auto-hyphenation for the first time | Bobosmite | Word | 3 | 12-12-2011 12:07 PM |