Posted to microsoft.public.excel.programming

vee[_3_]

external usenet poster

Posts: 1

fill in hour in excel sheet

Hi

Please help i need to covert these values:
:04:34 to be 00:04:34 in a excel sheet

these are time values & i dont know how.

another example
1:57:41-is correct
:08:35 needs to add 00 to be 00:08:35

thnks
vee

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
How do i get an form to fill up my excel sheet?	raj	Excel Discussion (Misc queries)	1	May 16th 09 04:12 PM
24 hour time sheet	time formula	Excel Worksheet Functions	2	October 26th 07 02:37 PM
auto fill from another sheet in excel	bluegrass	Excel Worksheet Functions	2	April 9th 06 07:45 PM
convert decimal numbers to a fraction of an hour for payroll hour	Flower	Excel Worksheet Functions	4	February 10th 06 07:46 PM
MIcrosoft Excel: should allow sheet increase by 1 on fill down	albertmb	Excel Discussion (Misc queries)	7	January 17th 06 02:48 PM

All times are GMT +1. The time now is 04:41 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us