Converting time.

**Marcol** · 02-09-2011, 02:56 AM

Try this

With Column A formatted "hh:mm" and Column B formatted "General" or "Number" Decimal places to suit (2)

In B2

=A2*24

Drag/Fill Down

Hope this helps

**Rahul Nagar** · 02-09-2011, 03:02 AM

Originally Posted by Marcol

Try this

With Column A formatted "hh:mm" and Column B formatted "General" or "Number" Decimal places to suit (2)

In B2

=A2*24

Drag/Fill Down

Hope this helps

Hi Marcol
The answer is right...can you please let me know the logic for the same.