Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
template or formula for start time -finish time -total hours ple | New Users to Excel | |||
Need to round the time to the nearest quarter hour. Help | Excel Discussion (Misc queries) | |||
time sheet to calculate 2 different columns | Excel Worksheet Functions | |||
Calculate difference in time spanning a day, during office hours o | Excel Discussion (Misc queries) | |||
How do I calculation time in excel in 24 hour method | Excel Discussion (Misc queries) |