Time

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

snikta - 02 Nov 2007 20:23 GMT

I am creating a time sheet. I need to convert a time format (7:30) to a
decimal format (7.50). How do I do this?

Reply to this Message

Teethless mama - 02 Nov 2007 20:33 GMT

=A1*24

Format cell as General

> I am creating a time sheet. I need to convert a time format (7:30) to a
> decimal format (7.50). How do I do this?

Reply to this Message

Karen - 21 May 2008 17:18 GMT

Hello, I have been reading the posts on converting time to a decimal. It
worked for 36:24:03, but I can't get it to work for 2:14:03. I get a "value"
error. Can you help me with this please

> =A1*24
>
> Format cell as General
>
> > I am creating a time sheet. I need to convert a time format (7:30) to a
> > decimal format (7.50). How do I do this?

Reply to this Message

T. Valko - 21 May 2008 22:17 GMT

Assume cell A1 = 2:14:03

Enter this formula in a cell:

=ISNUMBER(A1)

What result do you get? If A1 is a real time value then this formula will
return TRUE.

If you are using this formula:

=A1*24

And it retuns a #VALUE! error then there's a problem with what's entered in
cell A1.

Signature

Biff
Microsoft Excel MVP

> Hello, I have been reading the posts on converting time to a decimal. It
> worked for 36:24:03, but I can't get it to work for 2:14:03. I get a
[quoted text clipped - 8 lines]
>> > a
>> > decimal format (7.50). How do I do this?

Reply to this Message

Karen - 21 May 2008 22:34 GMT

Thank you. I will try again. I appreciate your answer.

> Assume cell A1 = 2:14:03
>
[quoted text clipped - 24 lines]
> >> > a
> >> > decimal format (7.50). How do I do this?

Reply to this Message

Karen - 22 May 2008 13:52 GMT

Here I am again. I tried every format available and nothing works. The
formula does come back false every time. Any other suggestions besides doing
it manually?
Thank you.
Karen

> Assume cell A1 = 2:14:03
>
[quoted text clipped - 24 lines]
> >> > a
> >> > decimal format (7.50). How do I do this?

Reply to this Message

David Biddulph - 22 May 2008 14:47 GMT

You've probably got spaces or other non-printing characters, before or after
the numbers.
--
David Biddulph

> Here I am again. I tried every format available and nothing works. The
> formula does come back false every time. Any other suggestions besides
[quoted text clipped - 34 lines]
>> >> > a
>> >> > decimal format (7.50). How do I do this?

Reply to this Message

Karen - 22 May 2008 16:32 GMT

Thank you. I've done that before when doing a copy & paste. I will try that.
Karen

> You've probably got spaces or other non-printing characters, before or after
> the numbers.
[quoted text clipped - 39 lines]
> >> >> > a
> >> >> > decimal format (7.50). How do I do this?

Reply to this Message

Michael - 02 Nov 2007 20:34 GMT

Multiply by 24 format cell as general

Signature

If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.

> I am creating a time sheet. I need to convert a time format (7:30) to a
> decimal format (7.50). How do I do this?

Reply to this Message

Gary - 02 Nov 2007 20:50 GMT

If the time is in A1, in B1 enter =(A1-INT(A1))*24

Hope this helps.

>I am creating a time sheet. I need to convert a time format (7:30) to a
> decimal format (7.50). How do I do this?

Reply to this Message