LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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
 
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 06: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 05:33 PM.

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

About Us

"It's about Microsoft Excel"