Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-03-2022, 06:27 AM
GRODD GRODD is offline Auto add time up and cost Windows 11 Auto add time up and cost Office 2021
Novice
Auto add time up and cost
 
Join Date: Aug 2022
Posts: 2
GRODD is on a distinguished road
Default 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
Attached Images
File Type: jpg Screenshot 2022-08-03 092630.jpg (54.0 KB, 7 views)
Attached Files
File Type: xlsx COST TEMPLATE FOR MS.xlsx (15.5 KB, 3 views)
Reply With Quote
  #2  
Old 08-03-2022, 10:56 PM
ArviLaanemets ArviLaanemets is offline Auto add time up and cost Windows 8 Auto add time up and cost Office 2016
Expert
 
Join Date: May 2017
Posts: 730
ArviLaanemets is a splendid one to beholdArviLaanemets is a splendid one to beholdArviLaanemets is a splendid one to beholdArviLaanemets is a splendid one to beholdArviLaanemets is a splendid one to beholdArviLaanemets is a splendid one to beholdArviLaanemets is a splendid one to behold
Default

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!
Attached Files
File Type: xlsx COST TEMPLATE FOR MS.xlsx (19.0 KB, 4 views)
Reply With Quote
  #3  
Old 08-04-2022, 08:59 AM
GRODD GRODD is offline Auto add time up and cost Windows 11 Auto add time up and cost Office 2021
Novice
Auto add time up and cost
 
Join Date: Aug 2022
Posts: 2
GRODD is on a distinguished road
Default

wow, thank you, love it

I'll play around with it
Reply With Quote
Reply

Thread Tools
Display Modes


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
Auto add time up and cost Cost resource not taken in real cost pascalbidouille Project 1 08-21-2015 01:25 PM
Auto add time up and cost Using auto-hyphenation for the first time Bobosmite Word 3 12-12-2011 12:07 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:39 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft