# how to calculate time start & time finish in quarter hour

=?Utf-8?B?UGV0ZXIgV3U=?=
Guest
Posts: n/a

 6th Jun 2006
I would like to show the difference between start and end time in hours and
quarter in Excel 2003. Example:

Start time End time Result
15.30 1.15 9.85

I would like to see the result column showing 9 hours and 3 quarters,
instead of 9.85 hrs. Can anyone help. Im using Microsoft

Peo Sjoblom
Guest
Posts: n/a

 7th Jun 2006
I don't see how 9.85 hours can ever be 9 hours and 3 quarters?

If you use start time 15:30 and end time 01:15, that gives a result of 9:45
or 9.75 using decimals, that is 3 quarters

you can round it to the nearest 0.25 and then use

=MOD(ROUND(A1*4,0)/4,1)/0.25

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey

"Peter Wu" <Peter (E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I would like to show the difference between start and end time in hours and
> quarter in Excel 2003. Example:
>
> Start time End time Result
> 15.30 1.15 9.85
>
> I would like to see the result column showing 9 hours and 3 quarters,
> instead of 9.85 hrs. Can anyone help. Im using Microsoft

=?Utf-8?B?RGlnaXRhbER1Y2s=?=
Guest
Posts: n/a

 7th Jun 2006
Click in the cells you want to be formatted that way then go to:
Format->Cells->Fraction->As Quarters

This will result in 9.85 being displayed as 9 3/4

-DD

"Peter Wu" wrote:

> I would like to show the difference between start and end time in hours and
> quarter in Excel 2003. Example:
>
> Start time End time Result
> 15.30 1.15 9.85
>
> I would like to see the result column showing 9 hours and 3 quarters,
> instead of 9.85 hrs. Can anyone help. Im using Microsoft

=?Utf-8?B?U2ltb25DQw==?=
Guest
Posts: n/a

 7th Jun 2006
Try this:
=INT((EndTime-StartTime)/1)&" hours "&INT(MOD((EndTime-StartTime),1)/0.25)&"
quarters"

-Simon

"Peter Wu" wrote:

> I would like to show the difference between start and end time in hours and
> quarter in Excel 2003. Example:
>
> Start time End time Result
> 15.30 1.15 9.85
>
> I would like to see the result column showing 9 hours and 3 quarters,
> instead of 9.85 hrs. Can anyone help. Im using Microsoft

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post RichieB Microsoft Access Forms 3 12th Apr 2007 12:47 PM =?Utf-8?B?TGF1cmE=?= Windows XP Help 3 11th Nov 2006 06:25 AM pfsardella@yahoo.com.nospam Microsoft Excel Worksheet Functions 0 27th Oct 2003 09:34 PM Felipe Microsoft Excel Worksheet Functions 0 27th Oct 2003 08:32 PM MARCY Microsoft Excel Worksheet Functions 2 6th Oct 2003 05:49 AM

Features