Solved

Formula to convert hours to decimal

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

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Best Excel  formula for  this scenario 2 39
Unhide very hidden sheets with password 22 45
If help 9 49
average of calculation (TSQL) 4 8
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 …
In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

803 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