| Home > Forum Home > Analyzing Corporate Financial Data > Very good Excel helpline and design service. > Time functions in Excel | Share |
Time functions in Excel
Excel Help for Time Functions In Excel in Analyzing Corporate Financial Data
| Forum Topic | Login |
Time Functions In Excel | Rate this: (3/5 from 1 vote) |
 | This depends on how the data id format. If you have date and time values, you can use =HOUR(End-Start) with the same concept for MINUTE and SECOND. If you want text results you can use the TEXT function such as =TEXT(End-Start,"h") to get the number of hours. You may need to first convert the data to time values by using TIMEVALUE(Date). | |
| Excel Business Forums Administrator | ||
| Posted by Excel Helper on | ||
| View Full Post |
Excel templates and solutions matched for Time functions in Excel:Solutions: Conditional Formatting Functions Data Cleansing Data Clean Up Tools Automation Add-ins Work Efficiency Add-ins |