Format Time

M

MAX

I am working excel 2007 and I have a workbook which consists of 33 sheets.The
names of the first and last sheets are SAMPLE and SUMMARY respectively and in
between 01 to 31.
All I need is to arrange the time in the format of for example 04:31 from
cell A7 to A68 in sheets from 01 to 31. Is there a solution for this.

Thanks in advance.
 
A

Ashish Mathur

Hi,

Select A7:A68 on any one sheet and then Group all sheets from 01 to 31. Now
change the format as desired and the formatting on all grouped sheets should
change

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count the remaining weekdays in a data range excluding holidays and start/end dates 5
Macro for summarizing multiple sheets 1
separating date and time 5
Sum value between two dates and copy to new cell 7
Code in certain sheets 1
calculate total hours/minutes from two time cells 7
Sharing data from one worksheet to another 0
Subtracting time...again 2

Top