LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10
Default ROUND UP HOURS to the next quarter hour

Any suggestions on how to round up a decimal to the next quarter hour?

Time IN=A
Time OUT=B
ACTUAL TIME =C
ACT.TIME to DECIMAL=D
ROUND Up to quarter hour (in decimal)=E

A is formated as h:mm AM/PM
B is formated as h:mm AM/PM
C is formula +B1-A1; formated as hh.mm
D is formula =INT(I18*24)+MOD(I18*24,1)*60/100

I have tried the following for E:
=ROUNDUP(d1/0.25,0)*0.25

but where D is 0.20 E = .25 I would like 20 muniutes to round up to .50 hour

Or if D is
from 0.00 to 15.0 minutes then E = .25
from 16.0 to 30.0 minutes then E = .50
from 31.0 to 45.0 minutes the E = .75
from 46.0 to 60.0 minutes the E = 1.0


Thanks

 
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
Round time to quarter hour pdberger Excel Worksheet Functions 15 November 14th 07 03:52 PM
How do I round time to the nearest quarter of an hour Meghan New Users to Excel 6 July 7th 06 06:36 PM
how do I round hours worked to the next half hour with a 24hr shif gycoso3 Excel Worksheet Functions 1 March 28th 06 09:25 PM
Need to round the time to the nearest quarter hour. Help John Excel Discussion (Misc queries) 1 February 11th 06 06:41 AM
How can I round an hour to the nearest 1/4 hour? Ms Chewie Excel Worksheet Functions 5 December 21st 04 05:05 AM


All times are GMT +1. The time now is 05:26 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"