ExcelBanter - Converting Time

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Converting Time (https://www.excelbanter.com/excel-discussion-misc-queries/81485-converting-time.html)

ExcelNovice

Converting Time

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?

Toppers

Converting Time

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

Is this what you want?

"ExcelNovice" wrote:

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?

All times are GMT +1. The time now is 03:34 PM.