Search: | |||||

| ||||

Home » Forum » MS Office | RSS Feeds |

I am trying to create a formula which calculates time by tenths of an

hour. My calcuation works fine if I my elapsed time is 60 minutes or

less. The problem is if it is more than 60 minutes. Here is my sample

formula.

(Sum(A2:B2)/(60/10))

I am probably just overthinking it. Thanks for any help.

Didn't find what you were looking for?
Find more on Calculating Time in parts of an hour
Or get search suggestion and latest updates.

Related Topics:

- Write a class Time that has three data member hour,minutes and seconds.
- To calculate the time difference between two days
- calculate exeuction time
- type casting /converting seconds to a days hours minutes seconds
- Jasper Report - Running For Hours
- Time Difference for Page Creation time
- Display character which appears number of time equal half of maximum time
- write a program that enters double data into an ArrayList and calculate the total
- Calculate Total Sum
- How to calculate IRR
- Excel won't calculate my function
- Easier method to capture & paste calculated value?
- Calculating the no. of containers
- Calculating duration
- Add-Ins loaded into Excel
- Convert string like "=123+456+789" to Long and then calculate
- Application.Calculate fails
- calculating 'names' of text boxes in a form
- Calculating values in VB
- 2003 - ActiveSheet.Calculate Problem
- Calculate fields (Pivot Tables)
- Convert string like "=123+456+789" to Long and then calculate
- Calculating Ratios
- calculate Mean
- calculating area of a regular polygon