Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 9

time formats

when working out a time sheet for example, i want to be able to enter time
using a decimal point (.) instead of a colan(:) and be able to add them
together to get decimal hours.

ie. start 8.00 (8:00) finish 3.45 (15:45) = 7.75 (7:45)

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to 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
Converting time formats into actual time(minutes)	LeighM	Excel Discussion (Misc queries)	2	October 30th 06 05:15 AM
Help with time formats	[email protected]	Excel Worksheet Functions	3	May 16th 06 03:39 PM
Time Formats	rj	Excel Discussion (Misc queries)	3	January 26th 06 09:07 AM
time formats	Stephen Larivee	Excel Discussion (Misc queries)	3	August 5th 05 12:35 AM
Time Formats	Fran	Excel Discussion (Misc queries)	1	May 10th 05 01:15 AM

All times are GMT +1. The time now is 01:16 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us