Solved

Formula to convert hours to decimal

Posted on 2013-01-31
3
249 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 500 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

PaperPort has a feature called the "Send To Bar". It provides a convenient, drag-and-drop interface for using other installed software, such as Microsoft Office. However, this article shows that the latest Office 2016 apps (installed with an Office …
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

911 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now