Converting number format to time format
I need to find out how many hours about 25 classrooms are being used. Each classroom has multiple classes each week. The start and end times are in military time but without the colon ie. 0900 to 1300; not 09:00 to 13:00. When I try to format the cells to time, all the data disappears. Any ideas??
Without converting the start/end times, if you want to find out the difference, try:
=(REPLACE(B2,3,0,":")-REPLACE(A2,3,0,":"))*24 formatted as General to give total hours.
where A2 and B2 contain the start/end times as entered.
If you want to convert the times, do them in separate cells with formula:
=REPLACE(A2,3,0,":")+0 and =REPLACE(B2,3,0,":")+0
and then subtract the 2 and multiply by 24 and format as General.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks