Thanks experts. It works
Regards
Smitha
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Asa Rossoff
Sent: Friday, November 11, 2011 12:28 PM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ convert data in time to number without any
If you want a numeric result indicating the number of hours, use
=A1*24
(where A1 contains the "time")
And format as General or as a number / number with decimal places.
That will give you 5 instead of 5:00:00 AM, and it will, for example, give
you 5.75 instead of 5:45:00 AM.
If
=hour(a1)
On Fri, Nov 11, 2011 at 11:31 AM, smitha.kumari wrote:
> ** **
>
> Hours of an employee worked is shown as 5:00:00 AM.
>
> ** **
>
> I have to convert it into number 5. Please help.
>
> ** **
>
> Regards
>
> Smitha
>
> ** **
>
> --
> FORUM RULES (934+ members already
