Hello all,
I have four fields as follows: schedule date, schedule time, release date, release time. How do I creat a calculated field to show the diference in hours between schedule date/time and release date/time?
Thanks
Hello all,
I have four fields as follows: schedule date, schedule time, release date, release time. How do I creat a calculated field to show the diference in hours between schedule date/time and release date/time?
Thanks
A1: Date
B1: Time
C1: Date
D1: Time
Please Login or Register to view this content.
Assuming a2 = sched date; b2 = sched time; c2 = release date; d2 = release time
Please Login or Register to view this content.
If this helped, please click (*) Add Reputation
Or
Cell format [h]:mmPlease Login or Register to view this content.
Is it possible to display the numbers as negative and positive based on if it is less than or greater than the scheduled date and time?
Because the standard functions have to have the release date/time > sched date/time the formula gets quite complicated. I think this one works most of the time - I haven't tested all scenarios
Please Login or Register to view this content.
How do you want the result to look, excel can only handle negative time values in certain circumstances, would it be OK to show something like -67.5 to represent minus 67 hours and 30 minutes?
If so just use Ali's suggestion but multiply by 24 and format as number
=(C2+D2-A2-B2)*24
Audere est facere
I will give your suggestion a try daddylonglegs. I'll reply back with the resuts later today.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks