Bill Martin -- (Remove NOSPAM from address)

Posts: n/a

Sean Skallerud wrote:
One of the pieces of software we use gives us time in an awkward format.
16633 means 166 minutes 33 seconds. I need a formula to convert this figure
to a decimal respresentation of time (166.55 for the example listed
previously).

Any help will be much appreciated.

One approach:

[ ] = int(a1/100) + 100*(A1/100 - int(A1/100))/60

Bill

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Time Format Question	C A	Excel Worksheet Functions	1	July 5th 05 06:38 PM
rounding time question	lbfries	Excel Worksheet Functions	3	April 6th 05 08:23 PM
Work Hours Time Question	Qaspec	Excel Worksheet Functions	5	March 27th 05 02:58 PM
time formula question...	Greg	Excel Discussion (Misc queries)	5	February 25th 05 10:11 AM
Best time question	Daniel Bonallack	Excel Worksheet Functions	2	December 10th 04 11:37 PM

All times are GMT +1. The time now is 05:01 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us