in excel I wish to show 7:30 (7 hours 30 minutes) as 7.5 hours

  • Thread starter Thread starter Gerry
  • Start date Start date
G

Gerry

in excel I wish to show 7:30 (7 hours 30 minutes) as 7.5 hours, can I enter
7:30 and have the cell with a formula change it to 7.5
 
You could use another cell to hold this formula:

=a1*24
and format as general (or number)
 

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

How do I calculate total pay from pay rate times hours and minutes 4
decimals as hours change to minutes 1
Converting work hours to day/hours/minutes 3
Extracting number of hours as decimal... 4
CONVERT HOURS AND MINUTES TO INT 3
Imported data 1
Excel Lotto - How to find duplicate 6-number groups from result database? 2
How do I calculate time in excel (clock in and clock out 3

Back
Top