Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Calculating Time in parts of an hour

  Asked By: Leon    Date: Nov 26    Category: MS Office    Views: 1465
  

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.

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Geb Chalthoum     Answered On: Nov 26

Assuming that the range contains minute.... Your formula  works fine  for me.
If I put 60 in A2 I get 10...= 10 tenths.
If I then put 6... = 1/10 of an hour... in B3 I get 11... = 11 tenths of an
hour.

What sort of results are you getting?

 
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.




Tagged: