I get a scheduling report with time of day for the start of the appointment. There is another field with the number of hours. How can i use both to calculate the end time of the appointment?
I get a scheduling report with time of day for the start of the appointment. There is another field with the number of hours. How can i use both to calculate the end time of the appointment?
EndTime = StartTime + (Number of Hours/24)
If both cells are in Excel time format, e.g. 09:30:00 and 02:00:00 just add them together
Otherwise if t's 09:30 and 2 then just add start time and TIME(2,0,0)
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks