Posted to microsoft.public.excel.misc

Erika

external usenet poster

Posts: 120

Time Formatting

I am tracking my minutes on the phone. I have a spreadsheet that I enter my
minutes and seconds after every call. For example:

1.2
3.43
7.50

How do I keep a running total of how many minutes:seconds that I have been
on the phone? When format the sum to give me mm.ss it is giving me a crazy
result.

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 formatting	Wanna Learn	Excel Discussion (Misc queries)	2	July 27th 07 06:48 PM
Time formatting	dziw	Excel Discussion (Misc queries)	2	September 15th 05 01:30 PM
Time formatting	Fred Holmes	Excel Discussion (Misc queries)	1	March 16th 05 01:29 PM
time formatting and time categorizing (vlookup or data validation)	MarianneR	Excel Worksheet Functions	4	November 18th 04 03:24 PM
time formatting and time categorizing (vlookup or data validation)	MarianneR	Excel Worksheet Functions	0	November 18th 04 03:13 PM

All times are GMT +1. The time now is 12:42 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us