Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Peter Wu
 
Posts: n/a
Default how to calculate time start & time finish in quarter hour

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
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom
 
Posts: n/a
Default how to calculate time start & time finish in quarter hour

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 wrote in message
...
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



  #3   Report Post  
Posted to microsoft.public.excel.misc
DigitalDuck
 
Posts: n/a
Default how to calculate time start & time finish in quarter hour

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

  #4   Report Post  
Posted to microsoft.public.excel.misc
SimonCC
 
Posts: n/a
Default how to calculate time start & time finish in quarter hour

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
template or formula for start time -finish time -total hours ple cc New Users to Excel 1 March 27th 06 06:06 PM
Need to round the time to the nearest quarter hour. Help John Excel Discussion (Misc queries) 1 February 11th 06 07:41 AM
time sheet to calculate 2 different columns John Sullivan Excel Worksheet Functions 1 October 21st 05 06:48 AM
Calculate difference in time spanning a day, during office hours o frozenfusion Excel Discussion (Misc queries) 1 August 26th 05 10:39 AM
How do I calculation time in excel in 24 hour method Lloyd Excel Discussion (Misc queries) 7 July 18th 05 08:43 AM


All times are GMT +1. The time now is 08:11 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"