Time Format Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm working on creating a weekly time sheet log. I have the formulas all set
up, but the total times need to be formated for quarter hours. (Where I need
it to show "7.5" it shows "7.30")

Thanks,
Cynthia
 
You would have to convert to decimal hours for that, by multiplying by 24.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cumulative time calculation in Excel 2003 2
Excel Time Sheet - Rounding To Quarter Hours 2
Daily Time Sheets with Rounding 1
New User-Defined Function in Excel 2000? 5
TIME CALCULATION 5
Excel Time Rounding in Excel 2
Time Sheet Summary 1
Dividing hours to give days 2

Back
Top