View Single Post
  #1   Report Post  
Michaela
 
Posts: n/a
Default Help wtih date and time in the same cell


I can get it to give me the time but it will come up 0's in the date. As shown


A1 B1 C1
01/03/05 02:00 PM 01/03/05 02:59 PM 01/00/00 00:59

What I want it to do is show the same date ( i.e. 01/03/05) and minutes
using this function.(=TEXT(MOD(B15-A15,12),"hh"" hrs ""mm"" mins""") in the
same cell.

Also, if it runs into the next day I want to put time restrictions on it as
well. (i.e. the
work time ends 7pm and resumes at 8am)

I have figured out how to get the times Using this function too (b1-a1=c1)
gives the minutes, but I want to show the date as above shown B1, but I keep
coming up with what is shown in C1 above.

can any one help?