Posted to microsoft.public.excel.misc

gfkbob[_2_] gfkbob[_2_] is offline

external usenet poster

Posts: 5

Displaying Time in Excel

I would like to display time in minutes and seconds only even if over
an hour. If the amount of time is 65 minutes I would like it
displayed as 65:00 not 1:05:00. Is this possible in excel?

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
Displaying negative time in excel	Six Sigma Blackbelt	Excel Worksheet Functions	5	November 10th 06 10:42 PM
Displaying time from 00:00 to 0.00	North for Short	New Users to Excel	6	June 28th 06 05:45 AM
Displaying Unix time as date and time	[email protected]	Excel Discussion (Misc queries)	1	May 30th 06 10:28 PM
I displaying a range in Time within a cell in Excel.	Moricj	Excel Discussion (Misc queries)	1	May 4th 06 01:04 PM
Time displaying wrongly	Denise Robinson	Excel Discussion (Misc queries)	3	August 9th 05 02:30 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us