Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

excel converting time to percentage in timesheet

Status
Not open for further replies.

Chache68

Technical User
Apr 22, 2005
3
US
I am creating a simple timesheet in excel. I input my start and stop times and have a formula that tells me how much time was worked. How do I convert that to a percentage? i.e. 8 hrs 30 min converts to 8.5 hrs.

I saw this done once and am having a problem duplicating it.
 
multipy the time field by 24 and format the results cell as a number.
 


FYI

Why are Dates and Times so much trouble? faq68-5827

Skip,
[sub]
[glasses] [red]Be advised:[/red]When Viscounts were guillotined just as they were disclosing where their jewels were hidden, it shows to go that you should...
Never hatchet your Counts before they chicken! [tongue][/sub]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top