Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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, 11 views)
Attached Files
File Type: xlsx COST TEMPLATE FOR MS.xlsx (15.5 KB, 7 views)
Reply With Quote
 



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:08 AM.


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