CONVERT HOURS AND MINUTES TO INT

3

3Nails

Calculated hours and mintues from time;

16:00 (4PM) to 19:30 (7:30PM) is 3:30.

How can I convert the results 3 hours and 30 minutes to 3.5 hours?
 

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

Excel 2003 -- how do I change a time format 3
Need to convert hours and minutes to hours and tenths. 2
in excel I wish to show 7:30 (7 hours 30 minutes) as 7.5 hours 1
Subtract times? 2
How can I calculate hours into pay...in this format hh:mm:ss 2
How do I calculate time in excel (clock in and clock out 3
Calculating number of hours and minutes 6
dividing a number into hours and minutes 1

Top