Time Calc with rounding.

		Microsoft Office Forums > Microsoft Excel > Excel
Time Calc with rounding.

FAQ

Mark Forums Read

Thread Tools

Display Modes

06-26-2016, 07:12 AM

Kevin@Radstock Kevin@Radstock is offline

Windows 10 Time Calc with rounding.

Office 2016

Office 365

Join Date: Feb 2012

Posts: 94

Kevin@Radstock is on a distinguished road

Hi

I take it that you want decimal time! Format B1 & C1 as text, you can then enter "0", ie 0715.

In D1: =MROUND(MOD((--REPLACE(C1,3,0,":"))-(REPLACE(B1,3,0,":")),1),"00:15")*24

and format the cell "General".

Or for proper time

=MROUND(MOD((--REPLACE(C1,3,0,":"))-(REPLACE(B1,3,0,":")),1),"00:15")

and format as time.

Kevin

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Rounding Up or Down depending on Start & End time	richardst	Excel	4	06-21-2016 06:03 PM
Rounding to nearest 0.25	Guloluseus	Excel	5	10-27-2015 11:28 PM
Trying to create a formula to calc if I add x new accounts, I will have to hire y tech/support ppl	glen123	Excel	7	07-28-2014 07:29 AM
XML List of lists in Excel or Calc	manofspider	Excel	1	08-05-2011 09:03 AM
Creating an Auto-Calc'd Date? Today+7 Days?	SoCalTelephone	Word	0	10-06-2010 10:27 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:17 PM.