If A1 contains the start date and time, then
=A1+3000/0.5/1440
and format the result as a date and time.
1440 is the number of minutes in a day.
If A1 contains the start date and time, then
=A1+3000/0.5/1440
and format the result as a date and time.
1440 is the number of minutes in a day.
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks