Hi
I know how to calculate time elapsed in hours using simple formulas in Excel, but it would be exceedingly helpful to be able to express the time elapsed as falling in specific intervals, i.e. <1 hour, 1-6 hours, 6-24 hours and > 24 hours. Is there an easy way to do this?
thanks !
Sure - use a nested IF - for a starting time in A2 and a end time in B2:
=IF(B2-A2<1/24,"< 1 hour",IF(B2-A2<=6/24,"1-6 hours",IF(B2-A2<=1,"6-24 hours",">24 hours")))
Bernie Deitrick
Excel MVP 2000-2010
Sure. I'd use a table to interpret the values and then look them up.
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
Another approach, please find the file attach
see u
Awesome, thanks ! I tried and modified it and it worked like a charm!
Thanks! I really appreciate the help!
Cool. Glad we could help out.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks