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