Hi,
I'm currently using the formula =MOD(D10-C10,1)*E10 to calculate the number of total hours allocated to a task based on the time difference between start time (D10)/end time(C10) and the number of staff involved (E10). However, I need to update the recordings to include date started (A10) & time started (D10) - date ended (B10) time ended (C10). What would the formula be to work our the hours between the start date/time and the end date/time.
Thanks
I'm currently using the formula =MOD(D10-C10,1)*E10 to calculate the number of total hours allocated to a task based on the time difference between start time (D10)/end time(C10) and the number of staff involved (E10). However, I need to update the recordings to include date started (A10) & time started (D10) - date ended (B10) time ended (C10). What would the formula be to work our the hours between the start date/time and the end date/time.
Thanks