Hi and Welcome to JustAnswer.com
Are you using Excel?
The cells will only take time or date+time
is it possible for me to calculate the duration when there a date and time change?
How can I do that? I know how if it's in the same foday but don't know how to formulate it for continuation into the followin.g day
Please wait, I will find this out for you
ok how is the format of your date
not sure your question
did not consider date into the formula. so i need to know how to include it
For example: 18/10/08 13:14
Is that fine?
ok, now how do i display only the time in cells A1 AND B1?
See if you use date-time or only time, just format the cells as custom - [h]:mm
once done, you can simply subtract both cells
if i formate the cell " time" I can not calculate the duration of hours. so if i formulate using date-time i can custom display the cell [h]:mm which will give me the hours.
if you use only time and if the time is only one day ahead, it can be calculated
ok, thanks. i will try it.
Sure, let me know if you have further questions or kindly rate me below