?
Solved

Formula to convert hours to decimal

Posted on 2013-01-31
3
Medium Priority
?
266 Views
Last Modified: 2013-02-01
Hello,

Can someone please help me with the attached formula? i would like to show a negative time as a decimal. Can this be done?

Any help will be greatly appreciated!

Thank you!
Copy-of-Formula-to-convert-Hours.xlsx
0
Comment
Question by:vegas86
  • 2
3 Comments
 
LVL 26

Accepted Solution

by:
redmondb earned 2000 total points
ID: 38842365
Hi, vegas86.

You ar ehaving issues with these times because their not in Excel time format. (For example, if you put the formula =ISTEXT(B6) it will return TRUE.

The following formula will handle these cells...
=ROUND(IF(MID(B6,1,1)="-",-24*T(MID(B6,2,9999)),24*T(B6)),2)

Regards,
Brian.
0
 

Author Closing Comment

by:vegas86
ID: 38842409
Thank you for your help and your explanation!! it works perfectly :)
0
 
LVL 26

Expert Comment

by:redmondb
ID: 38843430
Thanks,  vegas86.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This holiday season, we’re giving away the gift of knowledge—tech knowledge, that is. Keep reading to see what hacks, tips, and trends we have wrapped and waiting for you under the tree.
In this post, we will learn to set up the Group Naming policy and will see how it is going to impact the Display Name and the Email addresses of the Group.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question