Posted to microsoft.public.excel.programming

GARYWC

external usenet poster

Posts: 80

Compute duration and miles-per-hour and total miles

When I format B as Time 00:00:00, the displayed result is 2:55:00

How can I get the display to be 2 HRS 55 MINS?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
Miles Calculation?	Ewing25	Excel Programming	3	April 29th 08 03:21 PM
Does anyone now how to calculate miles per hour using excel?	RuSLMaN	Excel Worksheet Functions	2	March 4th 08 02:36 AM
Miles Per Hour	WalkerDude999	Excel Worksheet Functions	1	May 7th 06 09:42 AM
How to use miles per hour and mileage to estimate travel time	OhioSnowBird13	Excel Worksheet Functions	1	February 21st 06 02:11 PM
convert 1.2 miles to meters	crlathem	Excel Discussion (Misc queries)	4	August 4th 05 10:47 AM

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

About Us

"It's about Microsoft Excel"