Prev Previous Post   Next Post Next
  #1   Report Post  
Tess
 
Posts: n/a
Default Duration

I have a field in time format of hh:mm:ss, which I've custom formated to [m]
to get total duration minutes. My problem is I need the seconds to round up
if they are more than 30. Is there a way to do this? I use this field for
conference call billing, if that helps.

Example:

47:05:35 formated to [m] reads 2825 and I need it to read 2826
--
Tess
 
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
Can't stop time duration [hh]:mm:ss converting to time of day Jack Cutrone Excel Discussion (Misc queries) 7 December 27th 04 11:23 PM
How do I convert a time eg. 00:01:39 to a duration eg. 1.65 min o. Louis Excel Worksheet Functions 1 November 22nd 04 01:36 PM
Excel Time Duration Formula Jackson Excel Worksheet Functions 2 November 4th 04 11:14 PM
Smart subtotals kortrijkzaantje Excel Worksheet Functions 0 October 29th 04 10:23 AM


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