hi and thanks!
I am needing a formula to reflect a percentage as follows:
i am calculating number of hours on the phone (i.e.: 8:30, (8 1/2 hours) minus number of hours off the phone (i.e. 1:45, (1 hour, 45 minutes). Then i need to show a percentage of time on the phone. How can I get a percentage when my format is in [h]:mm?
thx!
I am needing a formula to reflect a percentage as follows:
i am calculating number of hours on the phone (i.e.: 8:30, (8 1/2 hours) minus number of hours off the phone (i.e. 1:45, (1 hour, 45 minutes). Then i need to show a percentage of time on the phone. How can I get a percentage when my format is in [h]:mm?
thx!