LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 205
Default Time and rounding

I need to be able to not round in a time sheet.
Exp: week one total time is 40 and 1.45 ot
Sencond week is 40 and .38 OT
When you add the two OT you get 1.83, but using a format to add you get 1.84.
I need it to say 1.83 how do i change how it rounds?


 
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
Rounding Time? stoch05 Excel Worksheet Functions 2 October 18th 06 07:52 PM
Time rounding help Sanch Excel Discussion (Misc queries) 3 June 30th 06 06:37 PM
rounding up time to quarter hour increments kdp145 Excel Worksheet Functions 5 March 15th 06 12:05 AM
Rounding off TIME FJ Shepley & JM Pfohl Excel Discussion (Misc queries) 2 August 19th 05 12:58 AM
rounding time question lbfries Excel Worksheet Functions 3 April 6th 05 08:23 PM


All times are GMT +1. The time now is 02:51 AM.

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"