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 TopicLogin

Time Functions In Excel

Rate this:
(3/5 from 1 vote)
OopsThis 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 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