ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   entering time data (https://www.excelbanter.com/excel-discussion-misc-queries/67752-entering-time-data.html)

nick carriero

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



Bob Phillips

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






All times are GMT +1. The time now is 05:40 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com