Hi All,
I have data validation boxes containing numbers. 1 column is for # of hours the other column contains # quarterly minute options.
I need to find out how, when selected, the hours and minutes will calculate as hours and minutes rather than on a quarter system
i.e. column 1 column2 total or it add everything up but does not provide me with the total # of hour/minutes
1 :15 1.25
any help would be appreciated
Thanks!~
Perhaps:
=TEXT(A1&":"&B1,"hh:mm")
or
=TIMEVALUE(A1&":"&B1) and format as time
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
I should clarify.
I have 13 columns in this document. I want to add each hour amount and each quarterly minute selection and get a total number of hours
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
here is the practice document.
as you can see, I need the hours and minutes to correctly add like a clock counter and total the number of hours and minutes provided
This appears to work with your example worksheet:
Formula:
Please Login or Register to view this content.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
That worked perfectly!
Thank you.
Oh. You were SO close!
=SUM(I13:I40)/24+SUM(K13:K40)/1440
Thank you for giving feedback.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks