Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 661
Default Hours

Newbie question: I have a list of hours (see below) and want to round them
up to the nearest halftime in 15 minutes section. Example: 12h37 would be
rounded to 12h30, 12h46 would be 13h00, 13h05 would be 13h00, 13h17 would be3
13h30 and so on...

How can I easyly do so...please help!

Many thanks.


12 h 40
12 h 37
12 h 37
12 h 34
12 h 31
12 h 27
12 h 27
12 h 26
12 h 24
9 h 46
17 h 14
17 h 11
17 h 11
16 h 14
16 h 06
16 h 06
15 h 16
13 h 00
12 h 55
12 h 24
12 h 16
11 h 10
11 h 10
11 h 07

 
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
sumif and translate annual hours into weekly quarter hours se7098 Excel Worksheet Functions 23 October 11th 08 01:37 AM
wages - multiply hours and minutes by number of hours worked Carol (Australia) Excel Discussion (Misc queries) 6 April 1st 07 01:16 AM
Drivers Hours Timesheet - Calculate Hours Worked on Weekly Basis Graham Excel Discussion (Misc queries) 2 January 28th 07 08:40 PM
Apply a macro to all sheets - save me from hours and hours of work Excel'ed Failures Excel Programming 3 January 30th 06 05:48 PM
Convert hours and minutes in time format into fractions of hours.. Akern Excel Worksheet Functions 4 April 21st 05 02:56 PM


All times are GMT +1. The time now is 11:40 PM.

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

About Us

"It's about Microsoft Excel"