Forum Discussion
Time Formatting in Excel
I'm trying to create a simple spreadsheet to log times in Excel.
I select the cells to be formatted and apply a TIME format e.g. 13:30
I would would like to be able to type 1330 and get t...
Thanks for the response guys.
Will both of these options allow me to calculate the duration in hours and minutes between a time start cell and time finish cell?
Will both of these options allow me to calculate the duration in hours and minutes between a time start cell and time finish cell?
=IF(AND(<StartTime><=TIMEVALUE(TEXT(<TheCell>,"0#"":""##")),<EndTime>>=TIMEVALUE(TEXT(<TheCell>,"0#"":""##"))),TRUE,FALSE)
This is just the workaround.
In fact, AFAIK, there is no solution to manually input a integer value in a cell to be treated as a time value in excel.