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

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
 
A

Andy_N1708 via OfficeKB.com

Are you trying to calculate elapsed time?
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
Click to expand...
 
D

Dave Peterson

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

Countdown macro - display settings 2
How do I calculate total pay from pay rate times hours and minutes 4
Converting work hours to day/hours/minutes 3
decimals as hours change to minutes 1
Extracting number of hours as decimal... 4
CONVERT HOURS AND MINUTES TO INT 3
Imported data 1
Split hours and minutes in two different cells 6

Top