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 |
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 |
All times are GMT +1. The time now is 02:39 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com