Posted: 1/25/2013 1:40:46 PM EDT
|
I want to input a start time in one cell and a stop time in another cell, then I want a formula to calculate the elapsed time in either hours and minutes or in hours and tenths. If my start time and end time remains within the same day, I have no problem. The problem arises when the stop time carries over past midnight. I don't know how to get it to tell me that from 23:00 to 01:00 = 2 hours. Any ideas? |
For the hijack: Does anyone know how to use the search function in an Excell spreadsheet to look for things like 8-32, 10-32, etc without it automatically converting the numbers to dates? I created a sheet of different hardware that we stock at work and I can't search it for 10-32 because it converts it to October 1932. 
|
|
Quoted: For the hijack: Does anyone know how to use the search function in an Excell spreadsheet to look for things like 8-32, 10-32, etc without it automatically converting the numbers to dates? I created a sheet of different hardware that we stock at work and I can't search it for 10-32 because it converts it to October 1932. Format those cells as 'text'. |
|
Quoted:
Quoted:
For the hijack: Does anyone know how to use the search function in an Excell spreadsheet to look for things like 8-32, 10-32, etc without it automatically converting the numbers to dates? I created a sheet of different hardware that we stock at work and I can't search it for 10-32 because it converts it to October 1932. Format those cells as 'text'. I did. They show up as 10-32, 8-32, etc. It is when I try to use type something like that into search function that it refuses to cooperate. It comes back with "October 1932 not found" or something like that. |