3

In a library my calculated column calculates what date Monday is the week after a document is last Modified.

=Modified-WEEKDAY(Modified,2)+8

I also want to add the minutes and seconds (not the hours):

=Modified-WEEKDAY(Modified,2)+8&" "&TEXT(Modified,"mm:ss")

Unfortunately, I can't get it to work. I get '42856.4667361111 12:06' instead of the date and time (minus the hours). What am I doing wrong?!

Aashirya
  • 1,021
  • 1
  • 12
  • 34
Haz
  • 375
  • 1
  • 6
  • 21

1 Answers1

2

Try this. You will need to convert the first part to date format:

=TEXT(Modified-WEEKDAY(Modified,2)+8,"dd/mm/yy")&" "&TEXT(Modified,"mm:ss")

More information here

SharePointer
  • 3,046
  • 1
  • 13
  • 28