Link to home
Start Free TrialLog in
Avatar of Billa7
Billa7

asked on

Show time value in units

I need Experts advice. Is that correct if I use the formula, e.g. at cell H2 (Detail sheet)   with“=100 -(G3)” to show value in units?
Formula---Copy.xls
Avatar of Saqib Husain
Saqib Husain
Flag of Pakistan image
100-(G3) will give you 100 days minus 20 minutes and the result will be 99.986 "Days".

It all depends on how you want to look at the data and how you want to present it.
Avatar of Billa7
Billa7

ASKER

Hi ssaqibh,

Per-year I give 100.000 unit and I need to subtract data from Column D ( I'm not very sure how to convert the duration value into unit so that its give a logical answer) with this 100.000. Sorry if this is sounds silly.
Avatar of Billa7
Billa7

ASKER

Hi ssaqibh,

Actually 100 is representing 100%, but shows in unit value.
ASKER CERTIFIED SOLUTION
Avatar of Saqib Husain
Saqib Husain
Flag of Pakistan image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Billa7
Billa7

ASKER

Hi ssaqibh,

Thanks for the help