What you need to understand about dates and times in excel is...
a date is just a number representing the number of days passed since 1/1/900...and then formatted in a way that we recognize as a date. So, for instance, today (Wed Feb 2017) is actually 42781
Time is actually a decimal part of 1 (day), so 06:00 AM is 0.25, 12 noon is 0.5 and 18:00 (or 6 PM) is 0.75
sounds like your answer is correct, as Trevor suggested, just format it as needed
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Next question is how do i do that in a calculated field. B1 is Min of Time and B2 is Max of time. I tried putting into the formula bar in the calculated field ='Min of Time'-'Max of Time' but it came up with an error.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks