• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 379
  • Last Modified:

Excel formula calculate difference in two datetimes, answer in hours and tenths (decimal)

How can I create a new column that contains the difference between two datetime values, with the answer expressed in hours and tenths-of-hours?

Begin Date (in A1) = 6/9/2011  12:04:00 PM
End Date (in B1) = 7/1/2011  12:15:00 PM

Hours Spent = B1 - A1

The answer is 528:11 when I custom-format it with [hh]:mm , but I need it to show as 528.2 (decimal format).

Thanks in advance!
  • 2
1 Solution
zorvek (Kevin Jones)ConsultantCommented:
To display hours with a decimal or fractional part divide the value by 24 and format the result as a number as illustrated below.


barry houdiniCommented:
I think you need to multiply by 24 Kevin, so for the above try this formula


format result cell as number with 1 decimal place

If you need result to be exact 10ths (and not just displayed that way) use ROUND, too, i.e.


regards, barry
zorvek (Kevin Jones)ConsultantCommented:
Dang. Thanks Mr. Barry.
notawahoo2Author Commented:
So Simple!  

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now