Time Format Autofill
I wonder as to whether anyone could help?
I am completing a time recording spreadsheet and would like it set so if 2 is placed within a cell it will autofill to 02:00 - is this posssible. Many thanks, Simon. |
Time Format Autofill
Hi Simon,
Chip Pearson has one way to do that here. http://www.cpearson.com/excel/DateTimeEntry.htm HTH Martin "SiH23" wrote in message ... I wonder as to whether anyone could help? I am completing a time recording spreadsheet and would like it set so if 2 is placed within a cell it will autofill to 02:00 - is this posssible. Many thanks, Simon. |
All times are GMT +1. The time now is 02:54 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com