We help IT Professionals succeed at work.

Show time value in units

Billa7
Billa7 used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
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.

Author

Commented:
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.

Author

Commented:
Hi ssaqibh,

Actually 100 is representing 100%, but shows in unit value.
Maybe

=(D3-G3)/D3*100

is more appropritate.

Author

Commented:
Hi ssaqibh,

Thanks for the help