Converting Time

G

Guest

I am currently trying to convert time from employee time cards from the
following format:

April 3 In: 13:90
Out: 18.22


The decimal .99 equals 59 minutes. Any thoughts?
 
G

Guest

(out-in)*24 will give time in decimal hours i.e 5 hours 30 mins will be 5.50000

Is this what you want?
 

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

Need a formula for time conversion 7
converting formula for whole numbers to time 3
Convert time entered to decimal 6
converting time more than 24 hours to a decimal 2
Excel 2003 - Time Formats 5
How can I change time format to decimal without losing hours? 2
Arranging a data in required format 3
Converting minutes to tenths 2

Top