?
Solved

How do I RoundUp hh:mm to hh?

Posted on 2011-10-04
3
Medium Priority
?
190 Views
Last Modified: 2012-05-12
Hello experts again,

How do I ROUNDUP hh:mm to hh?

See attached example.

Thanks, Gary
Training-History-Log-EE-2.xls
0
Comment
Question by:garyrobbins
  • 2
3 Comments
 
LVL 81

Accepted Solution

by:
zorvek (Kevin Jones) earned 2000 total points
ID: 36912005
The CEILING function is useful for rounding values such as times up to the next multiple of significance. For example, to round a time up to the next 60 minute interval use the formula:

   =CEILING(A1,TIME(0,60,0))

Kevin
0
 
LVL 81

Expert Comment

by:zorvek (Kevin Jones)
ID: 36912013
See attached.

Kevin
Training-History-Log-EE-2.xls
0
 

Author Closing Comment

by:garyrobbins
ID: 36912057
Thanks, zorvek.  That is so cool!

Gary
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
This article describes a serious pitfall that can happen when deleting shapes using VBA.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question