Time as a fraction

G

Guest

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
 
J

JE McGimpsey

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.
 
S

Sandy Mann

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

--
HTH

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

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Time calculations 6
Time Calculated minus breaks & lunch 2
Time Sheet Function to Calculate 5
Prevent changing a fraction 2
If Function With A Time 5
Calculating Time 3
Format for Time Elapsed in Decimal 4
Help! creating code for time to decimal calculations 1

Top