Time as a fraction

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Graham F - 16 Jun 2007 21:20 GMT

Hi Group,

I need to express total time as a fraction, for example Excel shaws the
result of a time calculation as 8:30 which is eight hours and thirty minutes,
I need to have it as 8 1/2 or 8.50 hours, is this possible? Many thanks for
any help. Grahamj

Reply to this Message

JE McGimpsey - 16 Jun 2007 21:22 GMT

XL stores time as fractional days, so multiply hours by 24 to get
decimal hours:

A1: 8:30
A2: =A1*24

A2 returns 8.5 when formatted as general.

> Hi Group,
>
> I need to express total time as a fraction, for example Excel shaws the
> result of a time calculation as 8:30 which is eight hours and thirty minutes,
> I need to have it as 8 1/2 or 8.50 hours, is this possible? Many thanks for
> any help. Grahamj

Reply to this Message

Sandy Mann - 16 Jun 2007 21:24 GMT

Multiply the 8:30 by 24 and format as General or number.

Signature

HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

sandymann2@mailinator.com
Replace@mailinator.com with @tiscali.co.uk

> Hi Group,
>
[quoted text clipped - 4 lines]
> for
> any help. Grahamj

Reply to this Message

Rate this thread: