Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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.newusers
|
|||
|
|||
time data
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) | |||
Using an IF statement on time based data | Excel Discussion (Misc queries) | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Summing Time Data | Excel Discussion (Misc queries) |