Converting Time

[ExcelNovice]

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]

(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?