Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
entering time data
is there a way to enter minute second data e.g., 30:43 without having to
enter the hour (none of the data points are over 59 minutes duration) ---- i'm using the format [h]:mm:ss (since i want to add the values and the total will exceed several hours) --- it seems to require an entry of the form 0:30:43 in order for the cell to contain the correct value ---- is there a way to avoid entering the colons altogether thanx nick carriero |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
entering time data
Se response in public.excel
-- HTH Bob Phillips (remove nothere from the email address if mailing direct) "nick carriero" wrote in message ... is there a way to enter minute second data e.g., 30:43 without having to enter the hour (none of the data points are over 59 minutes duration) ---- i'm using the format [h]:mm:ss (since i want to add the values and the total will exceed several hours) --- it seems to require an entry of the form 0:30:43 in order for the cell to contain the correct value ---- is there a way to avoid entering the colons altogether thanx nick carriero |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Sort pages? | Excel Discussion (Misc queries) | |||
entering numbers to display a time format | Excel Discussion (Misc queries) | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |